Can I use two variables with SUMIFS


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!