Ask Your Question

OR in Calc cell

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

neti gravatar image

updated 2017-06-01 10:56:28 +0100

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 close merge delete

2 Answers

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 53 times

Last updated: Jun 01 '17