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})

2024-03-11_21-47-31.jpg

Find more posts tagged with

Accepted answers

Kelly Moore

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

All comments

Kelly Moore

Hey @Jessica Krueger

The syntax you're using for the SUMIFS isn't correct for the SUMIFS function. It's syntax is

=SUMIFS({Actual Effort},{Assets Needed}, "LMS: Addition", {Year}, 2024)

Will this work for you?

Kelly

Jessica Krueger

Yes! It worked. I should've just come here first. I've been fighting with it for hours. Thank you so much!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.