count function ???

  • Thread starter Thread starter dlotz
  • Start date Start date
D

dlotz

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!
=====================================================


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
 
Back
Top