Question

what is the purpose of subtotal?​

Answer 1

Answer:

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. This video show how to use SUBTOTAL or the newer AGGREGATE function, to work with filtered data.

Use SUBTOTAL With Filtered Lists

To show the difference between SUBTOTAL and COUNT, in the screen shot below, there is a list of orders with totals above the list. The list has been filtered to show only the West region’s sales.

Above the list, there are total counts:

In cell E1, the COUNT function is used, and even though there are only 6 orders visible, the order count is showing as 37.

In cell E2, the SUBTOTAL function is used, and it shows a count of the visible rows only.

HEY...BUDDY... THIS US YOUR ANSWER.. HOPE IT HELPS...PLS MARK IT AS BRAINLIEST....AND PLS ....FOLLOW ME... AND PLS... RATE THIS ANSWER......

Answer 2

Answer:

Subtotal adds data arranged in an array—that is, a group of cells with labels for

columns and/or rows. It is available in Data Tab, using the Subtotals dialog, you

can select arrays, and then choose a statistical function such as Count, Min, Max

etc. to be applied on arrays. For efficiency, one must choose up to three groups

of arrays to which to apply a function.

Explanation:_____________________________________________

Hope y'all like it :))