Welcome!

SUMIF using RYG Status

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.

Find more posts tagged with

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Cell Behaviour for Cross Sheet Reference Formula with Daily Source Sheet Data Refresh via Data Shuttle
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
Submit a survey with contact as Mandatory field
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…
starting out
I have no idea how to start the program. I need the basics on how to build charts and graphs.