Counting formula
 

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

Counting formula
 

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

Counting formula
 

=COUNTA(A1:A2)
--
Gary''s Student - gsnu200729

Counting formula
 

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

"FSt1" wrote:

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