SUMIF on Cross Sheets

Debbie.Hill103471

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

 

Paul Newcome

What is in Ranges 1 and 2?

 

The basic syntax in your formula will need some tweaking. It should be

 

=SUMIF(criteria_range, criteria, range_to_sum)

 

Based on that and some assumptions about your ranges, this may work for you...

 

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

Debbie.Hill103471

Paul,

thank you! that worked...

range 2 is the budget column from cross sheet , range 1 is the region column from cross sheet.

Debbie

Paul Newcome

Ah. Ok. Then the ranges should be swapped with each other in comparison to what I had originally posted.

 

Glad you got it working.