Forum Discussion
Using Sumwith sumifs for multiple critiera
Hi, i am trying to use sum with sumifs to add two criteria each from column A, B and C as shown in yellow highlighted portion. it add two criteria each from Column A and B, but not adding the third column.
You could simply use an Excel table with Total Row and filter.
I believe sumifs will group your criteria like this:
(Utility AND Asia AND Baden) OR (Game AND Europe AND WenCal)
But, are you actually trying to do this?
(Utility OR Game) AND (Asia OR Europe) AND (Baden OR WenCal)
Perhaps try:
=LET(criteria1, BYROW(--(A2:A28=K2:L2), LAMBDA(rw, SUM(rw))), criteria2, BYROW(--(B2:B28=K3:L3), LAMBDA(rw, SUM(rw))), criteria3, BYROW(--(C2:C28=K4:L4), LAMBDA(rw, SUM(rw))), SUM(D2:D28*criteria1*criteria2*criteria3))
