COUNTIF Function

06/29/18 Edited 12/09/19

Im trying to count 2 columns on a issue sheet and want to count out each specific type (Risk, Action, Issue, Decision) that are open (not counting the closed or in progress types)

I have these formuals but its not producing a result

  • =COUNTIF(Type1:Type50, "Risk", [Status1]:[Status50], "Open")
  • =COUNTIF(Type1:Type50, "Action", [Status1]:[Status50], "Open")
  • =COUNTIF(Type1:Type50, "Issue", [Status1]:[Status50], "Open")
  • =COUNTIF(Type1:Type50, "Decision", [Status1]:[Status50], "Open")

As an aside, why do I have to select a range and not just the entire column?

Any help experts? Thank you for any guidance. I'm one week into SS, loving it.


  • Found it!!

    =COUNTIFS(Type:Type, "Risk", Status:Status, "Red")

  • Mike WildayMike Wilday ✭✭✭✭✭

    Yep. You can reference the entire column by just using the column name between a colon. [Column Name]:[Column Name]

    Good find. 

Sign In or Register to comment.