Ask Your Question
0

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: 5.1.6.2) I want to count how often a cell contains the text "Done" in some range. I have tried the following expression:

=countif(J4:J30;"Done")

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
0

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

Stats

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

Seen: 35 times

Last updated: Jan 31