SUMIF Formula Help!

I am trying to type a sum if formula where it will add up a whole column based off of ONE criteria. The formula is working but it equals to 0 every time when that is not what the actual answer is. Please help!

Ex: I want to sum up the number columns where the region is would be 2 but it is coming out as 0.

What I am trying: =SUMIF({Number}, {Region} = "Asia")

Number Region

1 Asia

1 Europe

1 America

1 Asia

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!