Count values in a column based on values in a different column

lisamurzyn

I am trying to count all cells that are "green" that are also a "task". "Green" is in a column called "Health" and "task" is in a column called "task type".

=COUNTIF({Turnaround Plan Range 2}="Task" If(AND({Turnaround Plan Range 3}= "Green")

lisamurzyn

Oh - and when I try to break it down into pieces, the first part =Countif({Turnaround Plan Range 2}="Task") it returns "1" when there are something like 350 in the range. Very confusing.

Chris St. Louis

I have a similar question: On my metrics sheet I am trying to count Items from my "Issue Log" sheet that are HIGH (Priority column), and also have a Status of OPEN or INVESTIGATING or ESCALATED (3 of 5 possible options in the Status column).

Paul Newcome

You need to use a COUNTIFS and separate your range/criteria sets with commas.

=COUNTIFS(range, criteria, range, criteria)

Dan W

@lisamurzyn

Try This =COUNTIFS({Formula Range 1}, ="Green", {Formula Range 2}, ="Task")

Dan W

@Chris St. Louis

Try this =COUNTIFS(Status:Status, OR(@cell = "OPEN", @cell = "INVESTIGATING", @cell = "ESCALATED"), Priority:Priority, ="High")

Replace the status and priority with proper References if needed

Chris St. Louis

Thanks @Dan W - that worked for me.