SUMIF Formula Help!

Jenna Doucette

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

Andrée Starå

@Jenna_Doucette

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!

Lila De Vera

Hi @Jenna_Doucette try the following:

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

Jenna Doucette

Hi Lila,

Thank you, that is what I did.

Thanks,

Jenna

Andrée Starå

Hi @Jenna_Doucette

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!

Jenna Doucette

Hi @Andrée Starå

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.

Jenna Doucette

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

Andrée Starå

@Jenna_Doucette

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)

Jenna Doucette

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

Andrée Starå

@Jenna_Doucette

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

😉

Try this.

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

Jenna Doucette

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

Andrée Starå

@Jenna_Doucette

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!