Author Topic: i need some excel help... (Read 211 times)

coola · « **on:** April 10, 2006, 03:53:50 AM »

how do i find an average, i highlighted a whole column, and i wanted to know the average of all the numbers

cheers..

Mac 10 † · « **Reply #1 on:** April 10, 2006, 03:56:47 AM »

how do i find an average, i highlighted a whole column, and i wanted to know the average of all the numbers

cheers..

should just be =AVERAGE(B2..B10) or whatever it is u have selected.

coola · « **Reply #2 on:** April 10, 2006, 04:15:34 AM »

thats what i type ?

Mac 10 † · « **Reply #3 on:** April 10, 2006, 04:22:57 AM »

in the cell type

=AVERAGE(B2..B10)

but like I say you will have to change the B2..B10 to suit your own situation.

coola · « **Reply #4 on:** April 10, 2006, 04:25:40 AM »

ahhh ok, cheers man, got it

coola · « **Reply #5 on:** April 10, 2006, 04:36:31 AM »

10% above average

Login