SUMIF on Cross Sheets

Hello,

I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument. 

On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0"

=SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ East")

Any suggestions would be greatly appreciated

Debbie

 

2019-09-09_1427.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!