Forum Discussion
Solved
Best formula to use - Sumif? - Help
Hello I have attachted sample data below need a forumla for the cells in yellow I need to find the sum of c2 to c30 with both of the conditions present in adjacent cells in a44 and b44 ...
Use SUMIFS instead of SUMIF for this. In C44:
=SUMIFS($C$2:$C$29,$A$2:$A$29,A44,$B$2:$B$29,B44)
Fill down.
cmckernan1 And for auto fill formulas (dynamic spill array).
=MAP(A44:A55,B44:B55,LAMBDA(x,y,SUMIFS(C2:C29,A2:A29,x,B2:B29,y)))