Countif formula

Anne-Solene Monrouzeau

Hi,

I am building a formula to count the number of cells in a column that have a given value. =COUNTIF(Status:Status, "In Progress")

The cells in the Status columns have a vlookup formula. The countif formula does not work as it seems to not read the value of the cell but the formula. It was working before I added the formula. Any idea how to fix it?

Thanks,

Anne-Solene

Anne-Solene Monrouzeau

The correct formula is =COUNTIF(Status:Status, @cell = "Not Started")

Genevieve P.

Hi @Anne-Solene Monrouzeau

I'm glad you found a solution! Thanks for posting it. Let us know if you have any other questions for the Community.

Cheers,

Genevieve