Loading...

Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columns

9,232 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 7, 2011

Download file: https://people.highline.edu/mgirvin/E...
How do you calculate an average with multiple conditions (criteria) when the data is spread out across multiple worksheets and multiple columns? Here is some of what you will learn:
1. Learn how to mash columns together using the INDIRECT function
2. Learn how to mash columns together using the CHOOSE function
3. Learn how to compare criteria against mashed up columns
4. See the functions: SUMIFS, COUNTIFS, SUM, SUMPRODUCT, AVERAGE, IF, INDIRECT, CHOOSE, ISNUMBER, and SEARCH
5. See how to use approximate criteria or Fuzzy Match using wildcards and the SEARCH function

From Mr Excel Message Board barry houdini and Domenic

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...