Can I use two variables with SUMIFS

Desmond Smith

Example, I have a smartsheet with sales, it has customer name, segment (i.e.: commercial, retail, sled, enterprise), country and total value.

Can I have use SUMIFS to show value of all deals in a segment by country? So like I want to show total for all Americas deals in the enterprise segment?

I've tried, but I must be doing it wrong.

Paul Newcome

It s just incorrect syntax. The proper syntax is

range to sum, range, criteria, range, criteria

You have

range to sum, range, range, criteria, criteria

Try this:

=SUMIFS({TEST SHEET for Formulas Range 1}, {TEST SHEET for Formulas Range 2}, "AMERICAS", {TEST SHEET for Formulas Range 3}, "ENTERPRISE")

Desmond Smith

As an example, here's what I "tried"

Note: The formula resides in a different sheet

=SUMIFS({TEST SHEET for Formulas Range 1}, {TEST SHEET for Formulas Range 2}, {TEST SHEET for Formulas Range 3}, "AMERICAS", "ENTERPRISE")

Paul Newcome

It s just incorrect syntax. The proper syntax is

range to sum, range, criteria, range, criteria

You have

range to sum, range, range, criteria, criteria

Try this:

=SUMIFS({TEST SHEET for Formulas Range 1}, {TEST SHEET for Formulas Range 2}, "AMERICAS", {TEST SHEET for Formulas Range 3}, "ENTERPRISE")