Countifs function to count ratings by location within the past 7 days

Bart13550

I am trying to create a countifs function to count 5-star ratings by restaurant location published within the past 7 days. The published column contains dates. So far, I have this equation:

=COUNTIFS(Rating:Rating, =5, Location:Location, "Bayshore", Published:Published,AND(@cell <= TODAY(), @cell > TODAY(-7))‌

I am getting an #unparseable error message.  What am I doing wrong?

Thanks!

Andrée Starå

Hi Bart,

There are a few ways to structure the formula. Here's one.

Try something like this.

=COUNTIFS(Rating:Rating; "Five"; Location:Location; "Bayshore"; Published:Published; <=TODAY(); Published:Published; >=TODAY(-7))

The same version but with the below changes for your and others convenience.

=COUNTIFS(Rating:Rating, "Five", Location:Location, "Bayshore", Published:Published, <=TODAY(), Published:Published, >=TODAY(-7))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD