From the course: Excel 2016: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using the AGGREGATE function to bypass errors and hidden rows

Using the AGGREGATE function to bypass errors and hidden rows

From the course: Excel 2016: Managing and Analyzing Data

Start my 1-month free trial

Using the AGGREGATE function to bypass errors and hidden rows

“

- [Voiceover] On this worksheet called Aggregate, we've got a list over in columns A through H, I'll double click the active cell, just to point out how deep this goes, down to our 742. And we're trying to get some totals here, now, in column J, our various formula, and they're all ending up with errors, different kinds of errors here. Column K, by the way, is using relatively new function in excel, it simply shows us what the formula is in column J, this is called formula text. So, that's handy, this is like documentation for the cells, just to the left. So, we've got problems in all cases here. We're trying to tabulate data, as you can see in all these examples, out of columns F and G. And here's an average function being used, right here. You might have seen how to use this in a prior movie. The average of function here is trying to tabulate the average compensation amounts for all of our full time people, using the data, of course, in column G, but it's not working. And the reason…

Contents