Ask Your Question

Unable to count the number of cells with specific content.

asked 2019-01-31 09:40:35 +0100

alex5730 gravatar image

In a spreadsheet (Version: I want to count how often a cell contains the text "Done" in some range. I have tried the following expression:


but I only get an error popup

Invalid Value

What am I doing wrong?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-31 09:50:40 +0100

alex5730 gravatar image

I know why I have this problem. I have marked the cells with "Data -> Validity", and that formula was, no surpise, not in the list of allowed values.

The formula works as expected...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-31 09:40:35 +0100

Seen: 113 times

Last updated: Jan 31 '19