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
Comments
-
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})
-
Paul,
thank you! that worked...
range 2 is the budget column from cross sheet , range 1 is the region column from cross sheet.
Debbie
-
Ah. Ok. Then the ranges should be swapped with each other in comparison to what I had originally posted.
Glad you got it working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!