software

For example:
A1 has a value;the # of bills worked..In this case, 11.
A2 through A9 have a decimal time of hours worked.

A2=.58 (hours)
A3=.92
A4 has no value
A5=.92
A6=.92
A7 has no value
A8=.58

A4,A7,and A9 have no values and are left blank.

What I'm after is a formula for A10 that will give me the value of
A1/(number of values entered in A2 through A9)
In this case, A1/5, since 5 out of the available 8 cells had a value. I
want it to count how many cells have a value entered in A2 through A9.

Any way of making a formula like this?

Thanks!--
bellz
------------------------------------------------------------------------
bellz's Profile: www.excelforum.com/member.php...oamp;userid=30429
View this thread: www.excelforum.com/showthread...hreadid=500989Hi!

Try this:

=IF(OR(COUNT(A2:A9)lt;1,A1=quot;quot;),0,A1/COUNT(A2:A9))

Biff

quot;bellzquot; gt; wrote in
message ...
gt;
gt; For example:
gt; A1 has a value;the # of bills worked..In this case, 11.
gt; A2 through A9 have a decimal time of hours worked.
gt;
gt; A2=.58 (hours)
gt; A3=.92
gt; A4 has no value
gt; A5=.92
gt; A6=.92
gt; A7 has no value
gt; A8=.58
gt;
gt; A4,A7,and A9 have no values and are left blank.
gt;
gt; What I'm after is a formula for A10 that will give me the value of
gt; A1/(number of values entered in A2 through A9)
gt; In this case, A1/5, since 5 out of the available 8 cells had a value. I
gt; want it to count how many cells have a value entered in A2 through A9.
gt;
gt; Any way of making a formula like this?
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; bellz
gt; ------------------------------------------------------------------------
gt; bellz's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30429
gt; View this thread: www.excelforum.com/showthread...hreadid=500989
gt;
Hi,

You can try

=A1/COUNTIF(A2:A9,quot;gt;0quot;)

Regards

Govind.

bellz wrote:
gt; For example:
gt; A1 has a value;the # of bills worked..In this case, 11.
gt; A2 through A9 have a decimal time of hours worked.
gt;
gt; A2=.58 (hours)
gt; A3=.92
gt; A4 has no value
gt; A5=.92
gt; A6=.92
gt; A7 has no value
gt; A8=.58
gt;
gt; A4,A7,and A9 have no values and are left blank.
gt;
gt; What I'm after is a formula for A10 that will give me the value of
gt; A1/(number of values entered in A2 through A9)
gt; In this case, A1/5, since 5 out of the available 8 cells had a value. I
gt; want it to count how many cells have a value entered in A2 through A9.
gt;
gt; Any way of making a formula like this?
gt;
gt; Thanks!
gt;
gt;


Thanks guys,
I'll try those when I get to work tomorrow.--
bellz
------------------------------------------------------------------------
bellz's Profile: www.excelforum.com/member.php...oamp;userid=30429
View this thread: www.excelforum.com/showthread...hreadid=500989