Ignoring hiddin values

[chrispy]

I am using the following formula to determine advertising co-op totals.
=((SUMIFS(F2:F45,$D$2:$D$45,$A$51,$E$2:$E$45,$B$51)*0.5)+(SUMIFS(F2:F45,$D$2:$D$45,$A$51,$E$2:$E$45,$C$51)*0.25))*-1

Column F contains advertising costs
Column D contains Y or N (if it qualifies for co-op)
Column E contains percentage of co-op (50% or 25%)
A51=Y
B51=50%
C51=25%

My issue is that this formula does not ignore values when I hide rows.
How can I modify this formula to ignore hiddin values.
All other totals use a formula such as =SUBTOTAL(109,F2:F45) but I can not seem to make this work with the SUMIF() formula.

 

[xenou]

Did you solve your problem? What filter criteria are you applying or which column are you filtering on?

ξ