Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting formula
=COUNTA(A1:A2)
-- Gary''s Student - gsnu200729 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTING FORMULA | Excel Worksheet Functions | |||
Counting formula | Excel Worksheet Functions | |||
formula for counting | Excel Worksheet Functions | |||
formula on counting | Excel Discussion (Misc queries) | |||
Help with counting formula | Excel Discussion (Misc queries) |