Reference 2 columns in another sheet and total up a 3rd column
I need to look for keywords in specific columns of another sheet (Assets Needed & Year), and if those parameters are found, take the value in the 3rd column (Actual Effort) and add them up.
I can get it to calculate if I have 1 parameter, but when I add the 2nd I get an #INCORRECT ARGUMENT SET message.
Here's the formula I'm using:
=SUMIFS({Assets Needed}, "LMS: Addition", {Year}, "2024", {Actual Effort})
Best Answer
-
Hey @Jessica Krueger
The syntax you're using for the SUMIFS isn't correct for the SUMIFS function. It's syntax is
=SUMIFS({range to be summed}, {range1}, criteria 1, {range2}, criteria2, etc). Also, enclosing your numeric year in quotes will make smartsheet believe it is a textstring, not numeric. Remove the quotes
=SUMIFS({Actual Effort},{Assets Needed}, "LMS: Addition", {Year}, 2024)
Will this work for you?
Kelly
Answers
-
Hey @Jessica Krueger
The syntax you're using for the SUMIFS isn't correct for the SUMIFS function. It's syntax is
=SUMIFS({range to be summed}, {range1}, criteria 1, {range2}, criteria2, etc). Also, enclosing your numeric year in quotes will make smartsheet believe it is a textstring, not numeric. Remove the quotes
=SUMIFS({Actual Effort},{Assets Needed}, "LMS: Addition", {Year}, 2024)
Will this work for you?
Kelly
-
Yes! It worked. I should've just come here first. I've been fighting with it for hours. Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!