Adding up "revenue at risk" in a sheet summary based on RYG status

Please can anyone give me a hand on how I can add up "revenue at risk" in a sheet summary based on RYG status?

I tried the following: =SUMIFS([Sales Price]:[Sales Price], Status:Status, "Red")

The Sales price column is formatted for US Dollars and I would like the "revenue at risk" summary to be in USD as well.

The status column mixes blanks, reds, yellows, and greens- not sure if that's relevant.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!