Agreed, my suggestion was focusing on this OP's line:
.. If either cell is empty I don't want it counted.

To me, it sounds from the line that OP wants either A or B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,900 Files:354 Subscribers:53
xdemechanik
---
"Peo Sjoblom" wrote in message
...
That would be either A or B not A and B
To me it sounds as if the OP wants A and B

"Basically I want to count the amount of times that there is data in
col a and col b along the same row"
^^^^^^^^^^^^^