Try this:

Lights/Solar in column B
Amounts in column C

Full unfiltered range is B2:C12

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B12,ROW(B2:B12)-ROW(B2),0,1)),(B2:B12="Lights")+(B2:B12="Solar"),C 2:C12)

--
Biff
Microsoft Excel MVP


"Robert" wrote in message
...
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