West Coast Connection Forum

Lifestyle => Tha G-Spot => Topic started by: coola on April 10, 2006, 03:53:50 AM

Title: i need some excel help...
Post by: 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..

Title: Re: i need some excel help...
Post by: Mac 10 † on April 10, 2006, 03:56:47 AM

Quote from: Chief 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..

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

Title: Re: i need some excel help...
Post by: coola on April 10, 2006, 04:15:34 AM

thats what i type ?

Title: Re: i need some excel help...
Post by: Mac 10 † 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.

Title: Re: i need some excel help...
Post by: coola on April 10, 2006, 04:25:40 AM

ahhh ok, cheers man, got it  ;)

Title: Re: i need some excel help...
Post by: coola on April 10, 2006, 04:36:31 AM

10% above average  8)