COUNTIFS OR Formulas

A Rose

Hi,

I want to count if range 1 contains value, or if it is any time in the future,

Range 1 is a restricted Date Column.

It should be something like this:

=COUNTIFS({Range 1}, "", >TODAY(), {Range 1}

What is the correct formula?

Thank you!

Genevieve P.

Hi @A Rose

You're close! In a COUNTIFS you first list the range, then you list the criteria. If you want to count the number of cells that are in the future, try this:

=COUNTIFS({Range 1}, >TODAY())

If you want to count two separate values, such as if it's blank OR if it's in the future, then you're right, you can use OR, like so:

=COUNTIFS({Range 1}, OR(@cell >TODAY(), @cell = ""))

Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi @A Rose

You're close! In a COUNTIFS you first list the range, then you list the criteria. If you want to count the number of cells that are in the future, try this:

=COUNTIFS({Range 1}, >TODAY())

If you want to count two separate values, such as if it's blank OR if it's in the future, then you're right, you can use OR, like so:

=COUNTIFS({Range 1}, OR(@cell >TODAY(), @cell = ""))

Let me know if this works for you!

Cheers,

Genevieve

A Rose

Amazing! Thank you @Genevieve P. !