Different in Sum/Subtotal(9,Range) and Subtotal(109,Range)
Sum- Using for normal range sum
Subtotal(9,Range):- Using for Filter value sum.
Subtotal(109,Range):-Using for hide value sum(Sum only visible value). Hide value not
sum.
Below image Explain Formulas
Below In normal table result
Unfilter 7 below Table (Hide 7 )
Note:- Subtotal(109 not sum hide value
Filter 7 qty in Qty from below table
In Filter Subtotal (9 and Subtotal 109 is Same working.
