The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
I dont know if any of you guys will be able to help me, but you've helped before and its worth a try.
My problem is:
How do you work out the average of a range of cells, ten (A1:A10) with only certain cells with numbers in them.
It divides by ten where as I would only like to divide the actual cells with the numbers in.
E.g. Ten cells with 5,6,1,2,2 in five cells comes to an average of 3.2, but because it divides by 10, the average is incorrect.
Any help is well appreciated.
Cheers.
My problem is:
How do you work out the average of a range of cells, ten (A1:A10) with only certain cells with numbers in them.
It divides by ten where as I would only like to divide the actual cells with the numbers in.
E.g. Ten cells with 5,6,1,2,2 in five cells comes to an average of 3.2, but because it divides by 10, the average is incorrect.
Any help is well appreciated.
Cheers.
Page:
Ah no, that was the problem originally.
Even though there are ten cells, only five of them may have numbers in. You need to divide by five, in that case.
Even though there are ten cells, only five of them may have numbers in. You need to divide by five, in that case.
(A1:A10)/10 may also do it......
AVERAGE(A1:A10) will do it..
I dont know if any of you guys will be able to help me, but you've helped before and its worth a try.
My problem is:
How do you work out the average of a range of cells, ten (A1:A10) with only certain cells with numbers in them.
It divides by ten where as I would only like to divide the actual cells with the numbers in.
E.g. Ten cells with 5,6,1,2,2 in five cells comes to an average of 3.2, but because it divides by 10, the average is incorrect.
Any help is well appreciated.
Cheers.
My problem is:
How do you work out the average of a range of cells, ten (A1:A10) with only certain cells with numbers in them.
It divides by ten where as I would only like to divide the actual cells with the numbers in.
E.g. Ten cells with 5,6,1,2,2 in five cells comes to an average of 3.2, but because it divides by 10, the average is incorrect.
Any help is well appreciated.
Cheers.
Page: