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.
Help Article Resources
Check out the Formula Handbook template!