Counting formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
sorry.
you said "in a row" so i wrote the fomula for that. but i just noticed that
your cells references are in a column(A). if so...
in A3 put...
=counta(A1,A2)
copy across????

Regards
FSt1
 
Back
Top