SUMIF with cross sheet referencing
Hello all,
I created a sumif formula that would reference another sheet.
Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone please assist?
Thank you,
=SUMIF({SIS Quarter 1 Range 1}, [Column15]48, {SIS Quarter 1 Range 2})
Comments
-
Try , =[Column15]48. The criterion is a condition that the SUMIF formula is looking for. In this case "equals this cell".
Here's a good reference: https://help.smartsheet.com/function/sumif
-
I believe it is actually a problem with your criteria (bold portion below).
=SUMIF({SIS Quarter 1 Range 1}, [Column15]48, {SIS Quarter 1 Range 2})
You would need to specify whether it equals, is less than or greater than, etc.
If that doesn't help, maybe post some screenshots so we can see what exactly you're working with.
-
Thank you! This helped!
-
Thank you very much!
-
Almost 4 years later this thread (and the other cross sheet reference threads) helped me. Thanks all!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 75 Community Job Board
- 502 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives