karrollsue
New Member
- Joined
- Nov 18, 2011
- Messages
- 11
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
=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
Last edited: