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
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!