Ask Your Question
0

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:

=CONTA.PIÙ.SE(DateSens;"<="&D3;DateFin;">="&D4;"")

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

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

Thanks!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

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
0

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

Comments

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

Stats

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

Seen: 53 times

Last updated: Jun 01 '17