Your formula syntax may be correct, but COUNTIF still cannot find the cells you are looking for. This usually happens because something in the criteria or the data is slightly different from what it appears to be.
Choose one of the causes below, then click Run to see how the formula works on the grid and why the result goes wrong.
=COUNTIF(B1:B6, "Done")Loading the interactive example…