I want to set a formula that only picks up the last 7 days

TeeM

Can somebody please help me with a formula to pick up some conditional data?

e.g. =COUNTIF(Column 1:Column 1, "SOLD") .....and then I want to add a condition showing entries in the last 7 days (including current day)

Paul Newcome

Try something like this...

=COUNTIFS([Column 1]:[Column 1], "SOLD", [Date Column]:[Date Column], @cell >= TODAY(-7))

TeeM

Brilliant. Thanks Paul.

Paul Newcome

Try something like this...

=COUNTIFS([Column 1]:[Column 1], "SOLD", [Date Column]:[Date Column], @cell >= TODAY(-7))

TeeM

Brilliant. Thanks Paul.