Sumifs with criterion range in column with multiple entry options

I track all of our projects on a single sheet, to include opportunities and finished projects. I want to sum the total sold amount. I have a column called "project status" that has 11 options for various status descriptions (i.e. pipeline, proposed, awarded, booked, complete, etc.). I'm trying to use this column as the criteria to sum the total sold, but I can't find a formula combination that allows me to use multiple entries in a column cell as criteria. I tried:

=sumifs([Contract Price]:[Contract Price], [Project Status] = "Awarded", [Project Status] = "Booked", [Project Status] = "Installing")

Do I need an OR statement in here? My preference is not to add a hidden helper column if I can help it.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!