| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average of column entries
I have a column of numbers and at the bottom I want the cell to display the
average NOT the total. Can this be done? Thank you, Rob, Teesside, UK |
|
#2
|
|||
|
|||
|
Try...
=AVERAGE(A1:A100) Hope this helps! In article , "abfabrob" wrote: I have a column of numbers and at the bottom I want the cell to display the average NOT the total. Can this be done? Thank you, Rob, Teesside, UK |
|
#3
|
|||
|
|||
|
IF, at the bottom means the status bar?? right click on it and change
-- Don Guillett SalesAid Software "abfabrob" wrote in message ... I have a column of numbers and at the bottom I want the cell to display the average NOT the total. Can this be done? Thank you, Rob, Teesside, UK |
|
#4
|
|||
|
|||
|
Thank you!!!
"Domenic" wrote: Try... =AVERAGE(A1:A100) Hope this helps! In article , "abfabrob" wrote: I have a column of numbers and at the bottom I want the cell to display the average NOT the total. Can this be done? Thank you, Rob, Teesside, UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
| Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
| how do i see if entries in one column are in another column? | New Users to Excel | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
