View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert Robert is offline
external usenet poster
 
Posts: 193
Default 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