Forum Discussion
Help with formula
Hello, I literally can not come up with the solution, and I have tried sum product or sum ifs, match 2 criteria`s to find the data belonging to it. Which formula should I be using? index&match ?...
Steven35-31 All the following formulas should work for you.
=SUMPRODUCT(($F$3:$N$14)*($D$3:$D$14=V5)*($F$2:$N$2=W5))
=FILTER(FILTER($F$3:$N$14,$D$3:$D$14=V5),$F$2:$N$2=W5)
=SUM(XLOOKUP(W5,$F$2:$N$2,XLOOKUP(V5,$D$3:$D$14,$F$3:$N$14)))