COUNTIFS Question--Calculation vs Filter Results

Felicia Levy · 12/15/21

This formula returns a count of 12

However, when I use the filters, I get a count of 10

Can you help me identify what the issue is in my formula? Why is it counting 2 more cells than the filter?

Thank you

Paul Newcome · 12/16/21

Your final criteria would be...

AND(@cell >= TODAY(-30), @cell <= TODAY())

Paul Newcome · 12/15/21

Are there any dates in the future? Your formula will pick those up.

Felicia Levy · 12/15/21

Yes! Oops! Can you advise how to rewrite the the date range in the formula to not pick up future dates?

Paul Newcome · 12/16/21

Your final criteria would be...

AND(@cell >= TODAY(-30), @cell <= TODAY())

Felicia Levy · 12/16/21

Thank you, that worked!

Paul Newcome · 12/16/21

Happy to help. 👍️

Best Answer