COUNTIFS for Projects Completed Within Past 90 Days

andyb · 04/09/19

For some reason I can't get this formula to work. I get 0 every time. Using a filter, I can see that number is incorrect. I want to count how many "Course" projects, per organization have hit complete in the past 90 days.

=COUNTIFS({Project Type}, "Course", {Organization}, Metric@row, {Completed Date}, <=TODAY(-90))

Paul Newcome · 04/10/19

For the past 90 days, you would need >= instead of <=.

andyb · 04/10/19

I checked that against a filter that I ran on the source sheet. when I use <=TODAY() and then close with >=(-90) I get the matching result to that of the filter. When I remove <=TODAY() and only leave >=(-90) I get a totally different number than what the filter shows.

I am wondering where the discrepancy is.

COUNTIFS for Projects Completed Within Past 90 Days

Comments

Help Article Resources

Categories