COUNTIFS Using Mulitple Criteria

Freddy Bustillos

I'm trying to get a count of rows where COLUMN 1 displays “Med” or “High” and COLUMN 2 displays a date in the past.

as. well as...

count of rows where COLUMN 1 displays “Med” or “High” and COLUMN 2 displays a yesterday's date.

Any help would be greatly appreciated!  

Genevieve P.

Hi Freddy,

It sounds like you just need to add in an OR statement to your COUNTIFS. Try this:

=COUNTIFS([COLUMN 1]:[COLUMN 1], OR(@cell = "Med", @cell = "High"), [COLUMN 2]:[COLUMN 2], <TODAY())

For your second formula, we can just change the "less than today" (the "in the past" statement) to say "is equal to Yesterday":

=COUNTIFS([COLUMN 1]:[COLUMN 1], OR(@cell = "Med", @cell = "High"), [COLUMN 2]:[COLUMN 2], =TODAY(-1))

Here are some Help Center articles I used to build this: COUNTIFS Function / @cell Function / OR Function / TODAY Function / Referencing Columns

Let me know if you have any questions about this.

Cheers,

Genevieve

Freddy Bustillos

That worked! Thank you SO, so much!

Genevieve P.

Hi Freddy,

It sounds like you just need to add in an OR statement to your COUNTIFS. Try this:

=COUNTIFS([COLUMN 1]:[COLUMN 1], OR(@cell = "Med", @cell = "High"), [COLUMN 2]:[COLUMN 2], <TODAY())

For your second formula, we can just change the "less than today" (the "in the past" statement) to say "is equal to Yesterday":

=COUNTIFS([COLUMN 1]:[COLUMN 1], OR(@cell = "Med", @cell = "High"), [COLUMN 2]:[COLUMN 2], =TODAY(-1))

Here are some Help Center articles I used to build this: COUNTIFS Function / @cell Function / OR Function / TODAY Function / Referencing Columns

Let me know if you have any questions about this.

Cheers,

Genevieve

Freddy Bustillos

That worked! Thank you SO, so much!

Genevieve P.

No problem! Happy to help 🙂