Countifs using a formula as a condition

[Weepypostman]

Sample spreadsheet (image): Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

I am trying to use a formula to count how many complaints have exceeded 60 days without a response, but it's not working. It's giving me an error about how i can't use a formula.

The formula I tried was =COUNTIFS((TODAY()-$E4:$E10000),>60,$I4:$I10000,"") There is obviously something wrong (i just dont know what it is...)

It's supposed to count if there is no date in PSTM/DCL column, and if Received date is more than 60 days prior to today's date. It has to fulfill both of those conditions to be counted.

Any help is appreciated. Thank you!

 

[Jonmo1]

Welcome to the board..

Put the TODAY in the Criteria argument, not the range..
Try
=COUNTIFS(($E4:$E10000),"<" & TODAY()-60,$I4:$I10000,"")

 

[Weepypostman]

Try
=COUNTIFS(($E4:$E10000),"<" & TODAY()-60,$I4:$I10000,"")

Wow..I feel really stupid now! Thanks for your help, works perfectly!