Forum Discussion
Sumif with filtered data
Hi all,
I am currently trying to calculate the sum of the 20' and 40' for each of the DGC charges ($28, $35, $38 etc) under the respective filter (Either by MTS or SRG under column G).
For example, assume that I am trying to calculate the sum of 20' under the DGC $28 using the filter for SRG, after using the formula =SUMIF(F:F,F3,C:C) , the total calculated is 145 includes the data for MTS whereas the actual value is supposed to be 116 for SRG.
How do I exclude the calculation for the filtered data?
1 Reply
=SUMPRODUCT((F3:F24=28)*(G3:G24="srg")*C3:C24)=SUMIFS(C3:C24,F3:F24,28,G3:G24,"srg")Maybe with either of these formulas.
