How to use SUMIFS

richard_uy

Hi,

When Currency in USD, Rebate Status is YES, how to compute the total of Sales Rebate? or total the Sales Rebate + Presales + CSP ?

Thanks in advance.

Andrée Starå

Hi Richard,

Your formula is in the wrong order.

A SUMIFS is in another order, so you start with the range that you want to SUM.

More info: SUMIFS

Try something like this. (Bold version are for your region)

=SUMIFS([Sales Rebate 4%]7:[Sales Rebate 4%]100; Currency7:Currency100; "USD"; [Rebate Status]7:[Rebate Status]100; "YES")

The same version but with the below changes for your and others convenience.

=SUMIFS([Sales Rebate 4%]7:[Sales Rebate 4%]100, Currency7:Currency100, "USD", [Rebate Status]7:[Rebate Status]100, "YES")

Depending on your country, you'll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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! 

Andrée Starå

Hi Richard,

Your formula is in the wrong order.

A SUMIFS is in another order, so you start with the range that you want to SUM.

More info: SUMIFS

Try something like this. (Bold version are for your region)

=SUMIFS([Sales Rebate 4%]7:[Sales Rebate 4%]100; Currency7:Currency100; "USD"; [Rebate Status]7:[Rebate Status]100; "YES")

The same version but with the below changes for your and others convenience.

=SUMIFS([Sales Rebate 4%]7:[Sales Rebate 4%]100, Currency7:Currency100, "USD", [Rebate Status]7:[Rebate Status]100, "YES")

Depending on your country, you'll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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! 

richard_uy

It work...yeh,...big thanks..😀

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help 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!