COUNTIF Function

06/29/18 Edited 12/09/19

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")

Comments

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    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

Sign In or Register to comment.