count function ???

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
 
R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Count Function 1
Help with finding numbers within text and summing 2
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
Event recognition. 6
nesting more than 7 functions? 11
Function for summing or counting cells based on a specified fill color 2
Count a number in a range with cells containing more than one numb 12

Top