Trouble with COUNTIFS Formula

kkinman

Hi,

I'm having some issues getting the syntax right for a COUNTIFS formula. I'm trying to count the number of cells that aren't blank in one range and is greater than or equal to 90 days from today in another range. Can someone provide assistance with this?

SSFeatures

Hi @kkinman, try this formula:

=COUNTIFS(Column:Column, <> "", Date:Date, @cell >= TODAY(-90))

This uses one range "Column:Column" and checks if it is NOT EQUAL TO "" (which is the empty text).

Then it checks a range of dates and checks if the value is within the most recent 90 days.

I hope this helps!

SSFeatures

Hi @kkinman, try this formula:

=COUNTIFS(Column:Column, <> "", Date:Date, @cell >= TODAY(-90))

This uses one range "Column:Column" and checks if it is NOT EQUAL TO "" (which is the empty text).

Then it checks a range of dates and checks if the value is within the most recent 90 days.

I hope this helps!

JR90

@kkinman you got to it before I could, but your formula is more simple than mine, here's what I got:

=COUNTIFS(Date:Date, >=TODAY(), Date:Date, <=TODAY(90), [Column2]:[Column2], NOT(ISBLANK(@cell )))

kkinman

Thank you, Nathan, that worked great!

SSFeatures

@kkinman You're welcome!

@JR90 that's a great formula too! Naturally my mind wants to use NOT(ISBLANK()) because it's the logical way to think through the formula. The shortcut "<>" is super nice too though haha.

JR90

@SSFeatures I did not know about the <> shortcut, very cool, thank you for that!