Trying to tally completion of task based on a date

[karrollsue]

I have a validated list of task in one column, then follow up dates in 2 more columns, then a completion date. My problem is counting completion dates against the task. Example if I had 12 of one task and 6 completion dates I need to be able to have six show up as complete towards that task. I tried 2 different ways and these are it.

=SUM((IF($B6:$B146, "Dental Exam",1,0)*(IF($H6:$H146<>,1,0))))

=COUNTIF($H6:$H146, "Immunizations")*COUNTIF($M6:M146,"<>*")

I tried several variations Column b is the task, column h is the completion date. I am puting the formulas in the cells next to the drop down validation list.

not sure whats wrong

 

[karrollsue]

Aladin Thanks a million, I had to put zero's back into the spreadsheet in place of blanks because of the hyperlinks. then adjusted the formula to count the zero in the Trim and it worked.

 

[Aladin Akyurek]

Aladin Thanks a million, I had to put zero's back into the spreadsheet in place of blanks because of the hyperlinks. then adjusted the formula to count the zero in the Trim and it worked.

You are welcome. Thanks for providing feedback.