Jul 25 2022 09:09 PM - edited Jul 25 2022 09:09 PM
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?
Jul 26 2022 01:05 AM
=SUMPRODUCT((F3:F24=28)*(G3:G24="srg")*C3:C24)
=SUMIFS(C3:C24,F3:F24,28,G3:G24,"srg")
Maybe with either of these formulas.