课程: Excel 2016: Managing and Analyzing Data

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Using the AGGREGATE function to bypass errors and hidden rows

Using the AGGREGATE function to bypass errors and hidden rows

课程: Excel 2016: Managing and Analyzing Data

开始一个月试用 购买团队方案

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…

内容