# 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 Asia...it 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

• ✭✭✭✭✭

Hi @Jenna_Doucette try the following:

=SUMIF({the column you want added}, {Region - I assume another column}="Asia")

• ✭✭✭✭

Hi Lila,

Thank you, that is what I did.

Thanks,

Jenna

• ✭✭✭✭✭✭

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭

Attached are some screenshots. I am trying to create a formula sheet and reference one external sheet but different columns for the SUMIF.

If the Region is APAC I would like to Sum the Planned Swing? column. I am trying (=SUMIF({Planned Swing?}, {Region} = "APAC") but when I do that for some reason it returns 0. The 1's are just numbers not a formula or anything. Please let me know if you need any more information.

• ✭✭✭✭

@Andrée Starå I've done these formulas multiple times I just do not know why this one isn't working....

• ✭✭✭✭✭✭
edited 09/25/20

Edit.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭

Incorrect Argument you have to do ="APAC" this is what it returns. The first range is the Planned Swing? column and the second is the region

• ✭✭✭✭✭✭
edited 09/25/20

Haha!  I edited my post, and in the meanwhile, you'd already seen it.

#### 😉

Try this.

=SUMIF({Region}, "APAC",{Planned Swing?})

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭

Thank you @Andrée Starå it worked!😊 Maybe my mind wasn't working yesterday with the logic hahah

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!