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:
http://www.excelforum.com/member.php...o&userid=30429
View this thread:
http://www.excelforum.com/showthread...hreadid=500989