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!
Make a COUNTIF(range,criteria1)+COUNTIF(criteria2)
Only make sure that conditions are mutually exclusive.
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 “;”
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.