31
Jan

What is the formula that you could use (instead of using the AVERAGE function) that would compute the average of the numbers in cells B1 thorugh B10?


Answer:
Simplest thing I can think of is

=sum(B1:B10)/10


Answer:
=SUM(B1:B10)/9

Yes it is 10…. my fingers got ahead of my brain!


Answer:
Sum, then divide by 10.

Answer:
=avg(b1:b10)

Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList

This entry was posted on Thursday, January 31st, 2008 at 4:09 pm and is filed under Software. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or TrackBack URI from your own site.

Leave a reply

Name (*)
Mail (*)
URI
Comment