This is the preety simple formula I am using with Excel 2010
=COUNTIFS(H1:H20,D80,L1:L20,"<>")
But it does not work with excel 2003
On the second criteria range (L1:L20) I want to count cells with any value (it could be anything except for blank cell)
Can you please provide an excel 2003 compatible forumal ?
I think its sumproduct, but not sure how to use it.
Thanks