SUMIF Formula Help!

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!

All comments

Lila De Vera

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

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!

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.

@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)

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?})

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