COUNTIF the date in one column is within the last 7 days of a date in another cell

• I'm stumped on this one.

This is what I need:
If the dates in I7:I106 are equal to "week ending date" (which will be changed every week in cell L3) or within the last 7 days of "week ending date", then COUNT cells J7:J106 if they equal the word "Deficient"

Any takers?

• Re: COUNTIF the date in one column is within the last 7 days of a date in another cel

A small example will be nice to prepare the formulas.
You want to count how many times L3 is included in the range I7:I106 then check if column J for the same rows is equal to Deficient

Triumph without peril brings no glory: Just try

• Re: COUNTIF the date in one column is within the last 7 days of a date in another cel

Try using COUNTIFS, i.e.

=COUNTIFS(I7:I106,">"&L3-7,I7:I106,"<="&L3,J7:J106,"Deficient")

• Re: COUNTIF the date in one column is within the last 7 days of a date in another cel

I just get an error when I try that. "The formula you typed contains an error"

• Re: COUNTIF the date in one column is within the last 7 days of a date in another cel

Did ever try to cange , to ;

Triumph without peril brings no glory: Just try

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!