Countifs between dates

[MartyCalavera]

Hello all,

First time poster here, but long term forum user! Finally I have come across a problem that I cannot find an answer for on this forum!!

I am trying to find the following: The number of supplier complaints that have been open for longer than 30 days. I have the below data in columns:

Supplier Name: B2:B20000
Complaint Open Date: D2:D20000
Complaint Close Date: E2:E20000
Status (Open or Closed): F2:F20000
Days Since Opening (Regardless of Status): I2:I20000
=Today(): K1
=Today()-30: L1

The formula I am trying to use is below, which returns all complaints that have been open longer than 30 days

When I use =COUNTIFS(D2:D50000,"<"&L1,F2:F50000,"Open") it returns all complaints open longer than 30 days, but I cannot find a way of adding in the 'per supplier' option?

Any ideas please?

Thanks!

Marty

 

[istiasztalos]

Hi Marty,

What do you mean by adding in the 'per supplier' option?