the _____ function of subtotal provide with in built function like sum,count,average,min,max etc
Answers
Answered by
4
Use the 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.
Answered by
3
Explanation:
The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and SUBTOTAL function can either include or exclude values in hidden rows.
hope this will help you
Similar questions
Science,
1 month ago
Accountancy,
1 month ago
Math,
1 month ago
Math,
4 months ago
Science,
4 months ago
Social Sciences,
11 months ago
Sociology,
11 months ago