Question

Explain the purpose of Subtotal with an example in 20 to 30 words​

Answer 1

Answer:

The syntax of the Excel SUBTOTAL function is as follows:

SUBTOTAL(function_num, ref1, [ref2],…)

GAO MIKADO ⚡️

MAKE ME BRAINLIST

Answer 2

Answer:

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.

Explanation:

mark as brilliant