Creating metric formula for referenced sheet

Good morning, I'm trying to sum a total estimate based on approval status for specific months/year. This is my formula:

=SUMIF({Totals FDC Status}, [Primary Column]@row, {R&R Total Estimate}, {R&R by month}, "8", {R&R by Year}, "2024")

Unfortunately, I'm getting "incorrect argument". I did ask AI but they do not reference other sheets yet. Can anyone help?

Thanks much 😊

Find more posts tagged with

Accepted answers

All comments

Kerry St. Thomas

You're super close. When you are trying to get a sum based on MULTIPLE criteria, you'd use SUMIFS (plural). Based on the formula references above, I think you'll want to go with something similar to this (though I'm not sure if I have assumed correctly which range is for which thing) -

=SUMIFS({R&R Total Estimate}, {Totals FDC Status}, [Primary Column]@row, {R&R by month}, "8", {R&R by Year}, "2024")

The first item is what you're summing up; the rest are the criteria RANGE and criteria VALUE that you'd use. More on SUMIFS here:
https://help.smartsheet.com/function/sumifs

Good luck!

Katkss

Thank you Kerry, I will give it a go. Much Thanks.

Kathy

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.