Forum Discussion
Question on Sumifs
Hello: Please can someone help me understand why formula is not able to work when it works in the first cell in K2 and K4? However, it doesnt seem to work for the rest of the rows up to row 10. Th...
Hi Maddy1010, your formula only worked for some rows because the ranges were not locked.
Correct formula: =SUMIFS($P$2:$P$10,$O$2:$O$10,R2,$N$2:$N$10,S2).
Table version: =SUMIFS(SourceData[Value],SourceData[Country],R2,SourceData[Company],S2).
Correct results are TW GM=5, TW GS=0, TW GG=8, US GM=2, US GS=3, US GG=0, CH GM=7, CH GS=1, CH GG=0.
You can also use a PivotTable and GETPIVOTDATA: =GETPIVOTDATA("Sum of Value",$A$14,"Country",R2,"Company",S2).