 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
17-03-06, 03:09 PM
|
#1 |
|
Guest
Posts: n/a
|
Microsoft Excel anybody?
Really dull. Does ANYBODY know how to add a column of figures and find the mean in microsoft excel? I can highlight them but what next? PLeeeeese?
|
|
|
17-03-06, 03:12 PM
|
#2 |
|
Guest
Posts: n/a
|
Use =average() putting the cell references in the brackets e.g. =average(a1:a10)
hope it helps |
|
|
|
17-03-06, 03:13 PM
|
#3 |
|
Guest
Posts: n/a
|
use the Average function
 eg. =Average(A1:A10) will return the mean of the numbers in cells A1-A10 |
|
|
|
17-03-06, 03:13 PM
|
#4 |
|
Member
Mega Poster
Join Date: Aug 2005
Location: Tower Hamlets but with Shutters on the windows
Posts: 1,522
|
click on the cell at the bottom of the column of figures .. then =AVERAGE(B1:B2) replace B1 & B2 with the cell numbers of those you wish to find the average of.
To insert a row/column highlight the row/column right click then click on insert |
|
|
|
17-03-06, 03:14 PM
|
#5 |
|
Guest
Posts: n/a
|
Or to do it quickly select all the figures and then right click where it says SUM=x in the bottom right of the status bar. Select Average and it'll show the average in the status bar.
|
|
|
|
17-03-06, 03:18 PM
|
#6 |
|
Guest
Posts: n/a
|
I HATE this programme........ anychance you could spell it out, like to a 5 year old?I found the function, put in the cell numbers in bracket, pushed ok and nuffing...
|
|
|
|
17-03-06, 03:27 PM
|
#7 | |
|
Guest
Posts: n/a
|
Quote:
|
|
|
|
|
17-03-06, 03:30 PM
|
#8 |
|
Guest
Posts: n/a
|
Does this make it clearer?
|
|
|
|
17-03-06, 03:33 PM
|
#9 |
|
Guest
Posts: n/a
|
Thanks for the tips, the programme itself has now been superceded by paper, pencil, and the back of an envelope. Far more enjoyable and reliable and you get to doodle whilst staring out the window.
|
|
|
|
17-03-06, 03:33 PM
|
#10 |
|
Guest
Posts: n/a
|
Excel
*laughs* |
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| HELP! Microsoft Excel doing my head in!! | -Ralph- | Idle Banter | 7 | 20-01-09 10:01 PM |
| MIcrosoft help... | aarond | Idle Banter | 6 | 10-11-08 08:01 PM |
| Can anybody help me with Microsoft Outlook | SV-net | Idle Banter | 3 | 29-10-08 07:13 PM |
| Microsoft Publisher | Tara | Idle Banter | 7 | 16-04-08 11:20 AM |
| New one in the face of MicroSoft | Baph | Idle Banter | 11 | 21-04-07 05:04 PM |
