Struggling with COUNTIFS

Alexis Taggard

=COUNTIFS(Status:Status, "Received" AND([ETA/Receipt Date]>=TODAY(-30)),[Merchandising Review - Rebecca]:[Merchandising Review - Rebecca], "Yes")

trying to add a stipulation here where status is Received but the actual date must be greater than past 30 days

keep getting #unparseable

John Jonassen

Hi @Alexis Taggard

You have an AND that you don't need, and missing a comma that you do. HA. Try this:

=COUNTIFS(Status:Status, "Received", [ETA/Receipt Date]:[ETA/Receipt Date], >=TODAY(-30), [Merchandising Review - Rebecca]:[Merchandising Review - Rebecca], "Yes")

John Jonassen

Hi @Alexis Taggard

You have an AND that you don't need, and missing a comma that you do. HA. Try this:

=COUNTIFS(Status:Status, "Received", [ETA/Receipt Date]:[ETA/Receipt Date], >=TODAY(-30), [Merchandising Review - Rebecca]:[Merchandising Review - Rebecca], "Yes")

Alexis Taggard

thank you! i knew it was something small i missed!