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 e...
=SUMPRODUCT((F3:F24=28)*(G3:G24="srg")*C3:C24)=SUMIFS(C3:C24,F3:F24,28,G3:G24,"srg")Maybe with either of these formulas.