ok
I am lookeing for a function that will no per-say count cells
fut produce the a value of 1 if there is any data typed in
specified range
so say my range is A1 to J1
I would K1 to render a value of 1 if there
is any data entered into the range

=SIGN(COUNTA(A1:J1))


" wrote:

ok
I am lookeing for a function that will no per-say count cells
fut produce the a value of 1 if there is any data typed in
specified range
so say my range is A1 to J1
I would K1 to render a value of 1 if there
is any data entered into the range

Try this:

=--(COUNTA(A1:J1)0)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


" wrote in message
...
ok
I am lookeing for a function that will no per-say count cells
fut produce the a value of 1 if there is any data typed in
specified range
so say my range is A1 to J1
I would K1 to render a value of 1 if there
is any data entered into the range