Need another set of eyes on SUMIFS formula in Sheet Summary

Kathy PPT

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

=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")

=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")

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