I have a final issue with my measurements sheet. I have several columns
designed to calculate how long it has taken people to do something ie, lines
minutes lines per hr
I then have a list of people and at the bottom of this list it then
calculates the average no of lines per hr, trouble is it includes any zeroes
also in the list, so instead of giving average of say the 2 people who did
job it also includes 0 from the other 9?
The formula i have at the moment is
=SUM(IF(ISNUMBER(E5:E13),E5:E13,0))/COUNT(E5:E13) originally this was due to
#DIV/0 issues which have been sorted. if i just use =AVERAGE(E5:E13) i just
get the same answer now,
can anyone help with my problem please,
Thanks,