How do I calculate within last 60 days?

Adi Sohoni

I am trying to calculate a sum of numbers in a column within last 60 days for a report and a dashboard.

I am trying to use this formula but it is not returning anything accurate.

=COUNTIFS(Date:Date, <TODAY(-60), [Total count]:[Total count], 1)

Total count is the column that I set up to count if the other checkbox column has a yes checked or not, if its a yes, it returns 1.

So basically I need to count only if its a "1" in the total count column.

Paul Newcome

Try this:

=COUNTIFS(Date:Date, AND(@cell >= TODAY(), @cell < TODAY(-60)), [Total count]:[Total count], 1)