Using sumif with subtotal
Lights 12,505.00
Solar 23,622.44
Lights 21,771.00
Solar 23,622.44
Lights 23,739.00
Solar 23,622.44
Lights 9,594.00
Solar 23,622.44
Using above data as example, how do I subtotal using sumif where data has
been filtered in a larger database? The filtered data base has returned data
that has already been correctly subtotalled using function_num 9. This list
now contains hidden rows. I now wish to further subtotal the list using
criteria lights or solar in the sumif?
--
Kind regards, Robert
|