Create SUMIFS formula

I need help creating a formula that will show the sum of the Forecast Amount for any Opportunity that has one of these Sales Stages:

1 - Prospect

2 - Assessment

3 - Proposal

4 - Contracts

If it's easier to write one that includes "everything except", these would be the ones to exclude:

Closed Won

Closed Lost

All I come up with is UNPARSEABLE.

Thanks in advance for your help!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!