Sumifs formula help

Hi, I am putting together a sumifs formula and it works for all criteria except this situation:

With my working formulas, my range is just a column value but now I need a formula with the same criteria but I need to range to be the sum of 2 columns.

This is my working formula with a single column range  =SUMIFS({2019 Master Tracker Total PO}, {2019 Master Tracker Customer}, "Crown", {2019 Master Tracker LOB}, "Maintenance")

The formula I am having issues with would be the same except the range would be {2019 Master Tracker Total PO} - {2019 Master Tracker Materials}

 

Thanks!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!