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
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives