COUNTIF & MATCH to find values in table column "Open", "Closed", "In Process"

[nkygal35]

I am trying to count the occurrences of a Status column that has the number of "Open", the number of "Closed", and the number of "In Process". I entered the formula to count the number of Open, but it returns #N/A. The format is General and there are a number of Opens but it does not count them.

Any ideas and where this formula is incorrect

=COUNTIF(INDEX(Table_Log[Status],0,MATCH("Status",Table_Log),0),"Open")

 

[steve the fish]

Hi. See if this works:

=COUNTIF(Table_Log[Status],"Open")

 

[nkygal35]

Thanks for such a quick response - it Works!