Forum Discussion
Formula required
I am busy setting up a progress report spreadsheet and need a count of the number of cells that contain 'Review completed on'. The problem is, I will not just be typing 'Review completed on' in the c...
You can use a wildcard:
=COUNTIF(range, "Review completed on *")
The * stands for 'any number of characters'.
Hans, you are a star.....thank you so much! 🙂