How do you find the average of multiple heights on Microsoft Excel 2010?

This can be done, however it will take a little bit of work and a long formula. This example assumes that the heights are in column A, beginning in A1.

First, enter this formula in cell D1, and fill the formula down through the last row in column A containing heights as depicted in your question.:

=IF(A1="","", LEFT(A1,FIND("'",A1)-1)* 12+RIGHT(A1,LEN(A1)- FIND("'",A1)))

Enter this formula in the cell you wish to return the average in:

=INT((SUM(D:D)/ COUNTIF(D:D,">0"))/12) & "'" & ROUND(MOD(SUM(D:D)/ COUNTIF(D:D,">0"),12),0)

If you wish to use a different column than 'D' for your formulas, change the four 'D:D' references to your column, i.e. F:F, M:M, etc. You can hide this column for aesthetics if you choose.

This will accommodate heights to 9'11".

Edit: The Average function in Excel will average numeric values only. The data presented in the question will be parsed by Excel as text, returning a #DIV/0 error if the Average function is applied to it.

interior the Excel 2010 record menu, there's a command that helps you to examine if the record is nicely suited with in the previous variations, and what particular aspects are not. you will ought to make mandatory changes to determine that formula calculate as meant. If the wizard comments that the record is nicely suited, you may merely save it through fact the older .XLS format. The 2003 consumer could additionally get carry of an improve that helps the newer .XLSX and .XLSM codecs to be edited (in spite of the fact that 2003 won't be able to use any of the newer helpful aspects).

"=Average( )" It is used to find the average of cells

Example

Student marks

{A1} 37

{A2} 80

{A3} 79

{A4} 90

{A5} =Average(A1:A4)

//This will add all the numbers in side cells from {A1} to {A4} and divide the number by the number of cells which are filled with a number

//37+80+79+90/4 =71.5

You can type the cell addresses manually or you can click the cell {A1} and drag to {A5} 0r

you can click on the "fx" icon and search for "Average" then type the cell addresses.

Still don't Understand

I have made a video tutorial on finding average on Excel 2010 watch it.

Visit

http://www.kingtechpc.blogspot.com/2013/02/ms-exce...

Add them together and divide it by how many hieghts you have