LinkBack URL
About LinkBacks
1 1 1 2.333333333
a1 b1 c1 d1 = a1+b1+c1/count(a1,b1,c1)
hi im try to get the average of cells, for some reason my formula is not working and i cant work out why above is what i put and the result im getting the result im looking for should be 1.
1 1 1 2.333333333
a1 b1 c1 d1 = a1+b1+c1/count(a1,b1,c1)
hi im try to get the average of cells, for some reason my formula is not working and i cant work out why above is what i put and the result im getting the result im looking for should be 1.
Your formula doesn't work because you are dividing just C1 by the count rather than the sum, either change to
=SUM(A1:C1)/COUNT(A1:C1)
or just use average function, i.e.
=AVERAGE(A1:C1)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks