what is the purpose of subtotal
Answers
Answered by
9
Explanation:
SUBTOTAL function to exclude filtered or hidden rows when calculating a total. You can choose any one of the 11 functions that SUBTOTAL can calculate, such as Sum, Average, Count or Max. This video show how to use SUBTOTAL or the newer AGGREGATE function, to work with filtered data.
Similar questions
English,
2 months ago
English,
2 months ago
Science,
2 months ago
Computer Science,
4 months ago
Social Sciences,
4 months ago
Social Sciences,
8 months ago
Chemistry,
8 months ago