AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() Whether you use 9 or 109, SUBTOTAL() will evaluate only the visible values-it will not evaluate hidden values. It's a quirk-just one of those little details you need to know about the function. Shouldn't the correct argument be 109? It's a valid question and I have an explanation, I just don't think it's a great explanation: SUBTOTAL() ignores rows that aren't included in the result of a filter, regardless of the argument you specify. Excel: Use AutoSum After Filtering Choose a cell in your data set. The following table lists this argument's acceptable values: Evaluates hidden valuesĪt this point, you might be saying, Wait a minute! The value 9 is supposed to evaluate hidden values. This argument tells Excel to sum the referenced values. You might think that's because of the first argument, the value 9. This function references the entire list, D6:D82, but it evaluates only the filtered values.Īlthough the SUBTOTAL() function references the entire list of values in column D, it evaluates only those in the filtered list. ![]() The solution is much easier than you might think! Simply click AutoSum- Excel will automatically enter a SUBTOTAL() function, instead of a SUM() function. ![]()
0 Comments
Read More
Leave a Reply. |