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