SUMIF for multiple columns

Originally Posted by makku

Hi,

I have the following situation:

Code Region1 Region2 Region1
XSAS $10.50 $11.50 $9.75

My worksheet contains many more columns! I need to sum the Code by Region as follows:

Code Region1 Region2
XSAS $20.25 $11.50


What is the right formula to use?


regards,

Depending on how many criteria you have, you can also use a sum with multiple (up to 7) IF statements. It's a Ctrl+Shift+Enter function.

={sum(if(A1:A25="XSAS",if(A1:Z1="Region 1",A2:Z2,0),0))}

Now for the ranges, you can input whatever you want depending on how big your range is. Hope this helps!