SUMIF using RYG Status

Patburke

Need help missing the boat on sumif based on status column using RYG. This is is a sales pipe line and trying to sort totals based on status.

Andrée Starå

Hi Pat,

Can you share a screenshot, the sheet or column what your column names are?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

Hi There, try this one: 

=SUMIFS([cost column title]:[cost column title], [RYG column Title]:[RYG column title], "Green")

• Replace "cost column title" with the title of the cost column that you want to sum together. 
• Replace "RYG column title" with the title of your column.
• And place whatever color that you are wanting to check against, Red, Yellow or Green in place of "Green" 

Hope that helps you get going. I used sumifs because its easy to add another condition in case you want to modify it to something else and works with even a single condition.