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
Best Answer
-
Excellent!
You're more than welcome!
Easy to miss and especially get SUMIF and SUMIFS confused. I'm thinking about only using COUNTIFS and SUMIFS instead.
🤣
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Answers
-
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
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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....
-
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
-
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
-
Excellent!
You're more than welcome!
Easy to miss and especially get SUMIF and SUMIFS confused. I'm thinking about only using COUNTIFS and SUMIFS instead.
🤣
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!