hi,
in c2 put.....
=counta(A2,B2)
copy down.
Regards
FSt1

"Neil" wrote:

I have 3 cells in a row and i would like the third cell to display a count of
the first 2 cells. Ie if A1 has data in it and A2 is blank i would like A3 to
display 1. And if both A1 and A2 have data in them for it to display 2.

Many thanks