Sign in to join the conversation:
I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow".
How would I add "Yellow" to this statement?
=COUNTIFS(Type:Type, "Risk", Status:Status, "Red")
I think you mean OR, since (at least in my system) Status can't be both Red and Yellow at the same time.
=COUNTIFS(Type:Type, "Risk", Status:Status, "Red") + COUNTIFS(Type:Type, "Risk", Status:Status, "Yellow")
or
=COUNTIFS(Type:Type, "Risk", Status:Status, OR(@cell ="Red", @cell ="Yellow")
should work.
Craig
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
