CONVERT OR FUNCTION RESULT ON A NUMBER

Hello everybody,

I'd like to add a column of results, but only if the content of the cells on the range are coincident with a precise text.

I mean, a colum presents text of several types: "CERRADO", "NO POR UBICACIÓN", "NO POR TIPO"...etc, and I have used the function CONTAR.SI (COUNT.IF, i guess, in English) for the range of cells on which "CERRADO", or "NO POR UBICACION", etc.

The problem (yet) is that I would like to add cells in which the content is those three expressions:

- "CERRADO"

- "2024"

- "ALGÚN DÍA"

but not the other ones with different content.

I have tried to ¿anidate? both functions, with this syntax, that is wrong because the result is #value

=CONTAR.SI(E2:E266;O("CERRADO","2024","ALGÚN DÍA"))

(=COUNT.IF(...........);OR("..."....)) in English, I suppose

I guess it is because the result of OR is TRUE or FALSE, not numeric results. But is there a way to use OR, or other function, to have as result 1 if any condition of OR is true, or 0 if all of them are FALSE?

What or how should I use those funcions?

Very thankful in advance to everyone.

Sergio Laspalas - ESP