NBVC - thank you for such a quick reply! this was my first time posting to this forum. Im loving it. I actually figured out how to do this moments after posting. I used: =COUNTA(D4:D75) and it did the job! I suppose if i had other data within those cells i would need to do it your way. thanks again!!