| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 64970 | 2006-01-03 08:27:00 | Help with EXCEL Averages | Billy T (70) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 417667 | 2006-01-03 08:27:00 | Hi Team I have some simple spreadsheets with columns of 16-20 figures. I want to be able to find the average of all the values in any given column. I am quite certain that I have done this before in a very simple fashion not requiring formulas etc but for the life of me I can't remember how. I could have done them all manually by now in the time I have wasted in the Help files and reading my EXCEL Dummies & "Easy Steps" books, but now I am getting ornery and I am determined to do it automatically or die trying. Cheers Billy 8-{) :mad: Can anybody help? |
Billy T (70) | ||
| 417668 | 2006-01-03 08:50:00 | In the bottom of the column where you want the answer, click on Autosum, then in the formula bar erase SUM and insert AVERAGE, then click the tick. | Slim (4633) | ||
| 417669 | 2006-01-03 08:55:00 | Once you have done the first column, get the gunsight on the answer, then drag to the right for all other columns. | Slim (4633) | ||
| 417670 | 2006-01-03 09:00:00 | In the bottom of the column where you want the answer, click on Autosum, then in the formula bar erase SUM and insert AVERAGE, then click the tick. Hmmm..... Thanks Slim Sounds simple (and familiar) but I can't find Autosum. I guess I need to display a toolbar but I'll have to go back to the Help files (or Dummies) to find out how.:( Cheers Billy 8-{) P.S. I have EXCEL 2000 Okay, I've got it now, thanks a million. :thumbs: |
Billy T (70) | ||
| 417671 | 2006-01-03 20:38:00 | www.ozgrid.com | kingdragonfly (309) | ||
| 1 | |||||