Ask Your Question

OR in Calc cell [closed]

asked 2017-06-01 10:55:09 +0100

neti gravatar image

updated 2020-09-08 15:38:33 +0100

Alex Kemp gravatar image

Hi, How can I put an OR condition within a function COUNT.IF?

this is it:


DateFin has to be >=D4 OR empty ("")

How can I make it work (D3 and D4 are numbers)


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-05 19:36:34.274433

2 Answers

Sort by » oldest newest most voted

answered 2017-06-01 11:05:02 +0100

Make a COUNTIF(range,criteria1)+COUNTIF(criteria2)

Only make sure that conditions are mutually exclusive.

edit flag offensive delete link more


yes, I'm using that solution now....

but on long expressions it duplicates thier lenght!

isn't there a shorter way?

the "|" that elsewhere works as an "or" it's automatically transformed in a ";"

neti gravatar imageneti ( 2017-06-01 11:44:07 +0100 )edit

answered 2017-06-01 13:32:13 +0100

Regina gravatar image

updated 2017-06-01 13:34:36 +0100

Or the legacy way =SUM((DateSens<=D3)*((ISBLANK(DateFin)+(DateFin>=D4)))) entered as array formula. I assume, that you are looking for empty cells in DateFin, not for those with an empty string.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-06-01 10:55:09 +0100

Seen: 89 times

Last updated: Jun 01 '17