I'm looking to add up filtered data using something like SUBTOTAL(109, range), where range is (say) $I9:$I$754. However, I only want to add those values where the contents in colum D of the row is (say) "B".

So - I'm trying to apply another condition to the SUBTOTAL in addition to the Filter.

Many thanks