Ask Your Question

Calc: Number of cells which don't have any of a set of values

asked 2018-10-02 15:53:29 +0200

alex72gr gravatar image

updated 2018-10-02 19:25:00 +0200

My problem:

I have a spreadsheet with quite much information. I need to check a large number of rows (actually I need to check each one of them separately). Some cells are empty (no value), some others have the character (value) "X", and some other have string values. So, I what I need to check for every single row (or more precisely, for a specific range of every single row) is how many cells: 1) are not empty AND 2) do not the have the value (character) "X" AND 3) do not have the any of the (string) values of three specific cells of my spreadsheet.For example, if I need to check the row 7 (range F7:Y7) and I need to know how many cells are not empty AND do not have the value (character) "X" AND do not have any of the values (strings) of the cells A7, B7 and C7, which formula should I use? I think that I should use the COUNTIF function, but I'm not sure what I should do...

Thanks in advance!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-02 18:59:15 +0200

erAck gravatar image

See also online help.

edit flag offensive delete link more


Thanks! It works!

alex72gr gravatar imagealex72gr ( 2018-10-02 19:17:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-02 15:53:29 +0200

Seen: 114 times

Last updated: Oct 02 '18