How can I count how many No" symbols I have in a column depending by a time range

Oana Intors

I need to know how many No I have last week.

This is how I try it but the result is always 0 ;(

=SUM(COLLECT({G1}, {G1}, "No", {G1 Date}, >=TODAY(-7)))

Please help.

Thank you

Heather Duff

Hi @Oana Intors ,

Try this:

=countifs({G1}, "No", {G1 Date}, >=TODAY(-7))

Also, make sure your G1 Date column is set as a date column in column properties.

Let me know if it works!

Best,

Heather

Oana Intors

It works perfectly, 😀

Thank you Heather D.