COUNTIF(AND) FUNCTION

Sarah_lee123

Hi again,

I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met.

1. the date is in the past
2. the progress status is not "Complete"

=COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range}, <>"Complete"))

#2 can also be accomplished by saying the {Done Range} is not checked.

Please advise where I am going wrong.

Thanks

Sarah_lee123

Update, I figured this one out

=COUNTIFS rather than =COUNTIF