Formula help with Sum ifs

Options
✭✭✭✭✭
edited 12/09/19

Hi,

I have done a formula for Countifs

=COUNTIFS({July Range unders}, <0, {July Range Manager}, [A/M]1)

This works well and returns the correct data, however i now want the total sum of these entries so tried the following:

=SUMIFS({July Range unders}, <0, {July Range Manager}, [A/M]1)

But this is pulling back an Incorrect argument.

Can someone kindly help with where i am going wrong.

Thank you as always for any help and support you can provide

Dave

Tags:

• ✭✭✭✭✭✭
edited 07/15/20
Options

Hi Dave,

It's not working because the SUMIFS function is structured differently.

SUMIFS(range criterion_range1 criterion1 [criterion_range2 ​criterion2 ​...])

What do you want to SUM?

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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.

• ✭✭✭✭✭
Options

Hi Andree,

I have shared the two sheets with you.

Basically i am trying to add up all the columns in sheet "July" that are under budget per manager, and consequently do the same for the over budgets. this is rolled up onto the data sheet.

You will see i have managed to get a total per manager but the two columns that are coloured named "overs" and "unders" is where i am struggling.

Thank you as always

Dave

• ✭✭✭✭✭✭
Options

Best,

Andrée

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.

• ✭✭✭✭✭
Options

Hi Andree

Wonderful help as always, thank you for taking the time to help me.

Regards

Dave

• ✭✭✭✭✭✭
Options

Thanks!

Happy to help!

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!