COUNTIFS for Projects Completed Within Past 90 Days

andyb

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}, [email protected], {Completed Date}, <=TODAY(-90))

Paul Newcome

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

andyb

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.