![]() The AGGREGATE function is what I like to call the Swiss Army Knife of functions because it can do so much. And you can specify whether you want to include or ignore hidden rows. Not only that, you can also use it to SUM, AVERAGE and more, as shown in the table below. The SUBTOTAL function is great for working with data that contains…wait for it, subtotals, because it automatically ignores any SUBTOTAL formulas in the range being summed. If you need more flexibility, the SUMPRODUCT function can handle AND and OR criteria. These functions treat all criteria as AND criteria, meaning each condition must be TRUE for the value to be included in the SUM/AVERAGE etc. Once you know one of these functions, the others are easy because they all have the same syntax, as you can see below: The SUMIFS function is one of the ‘IFS’ family of functions which enables you to aggregate data that matches criteria you specify. Still stuck? Download our IF formula builder and have your IF formulas written for you. ![]() A lot of people struggle with them, but once you master these functions you won’t look back. ![]() The AND and OR functions extend the number and type of logical tests you can specify when nested in the IF function. ![]() Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals. ![]()
0 Comments
Leave a Reply. |