Need another set of eyes on SUMIFS formula in Sheet Summary

Hi and Happy New Year,

Hope all is going well for you.

In the Project Intake Sheet, I'm using the Sheet Summary to calculate metrics for reporting. On this particular formula, I keep getting #UNPARSABLE. I haven't been able to figure it out all day. Appreciate any input you may have!

Goal:

To sum the values in the ARR column of Intake Sheet for projects with a status of "In Progress" or "On Hold"

Formula:

=SUMIFS([ARR]:[ARR], ([Project Status]:[Project Status], "In Progress"), OR(AND[Project Status]:[Project Status], "On Hold), [Year Started]:[Year Started], "2024"))

Columns:

ARR is a Dollar amount

Find more posts tagged with

Formulas

Sheet Summary

Multi-Select Dropdown

Accepted answers

=Chris Palmer

Hello @Kathy PPT

Something like this perhaps?

=SUMIFS([ARR]:[ARR], [Project Status]:[Project Status], "In Progress", [Year Started]:[Year Started], "2024") + SUMIFS([ARR]:[ARR], [Project Status]:[Project Status], "On Hold", [Year Started]:[Year Started], "2024")

All comments

=Chris Palmer

Kathy PPT

@Chris Palmer - thanks, that worked. I should know to go simple when complex is not working! :)

Paul Newcome

You can do this in a single SUMIFS like so:

=SUMIFS([ARR]:[ARR], [Project Status]:[Project Status], OR(@cell = "In Progress", @cell = "On Hold), [Year Started]:[Year Started], "2024"))

=Chris Palmer

https://community.smartsheet.com/discussion/comment/467306#Comment_467306

Awesome! Happy this worked for you :-)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.