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
- Customer Resources
- 64.8K Get Help
- 434 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!