question for all you gurus...

[confused man]

hi, I'm trying to get a formula but I'm not sure how to do it. I'm trying to
get the average of a set of numbers. I have the formula set up as:

=sum(H7:H354)/

and this is where I get stuck.. How can I tell excel to divide this sum by
the number of entries I have? it needs to be flexible enough to know adjust
the "n" if I were to add more cells.

Any help would be greatly appreciated.
Thanks again,
Confused Man

 

[Peo Sjoblom]

=AVERAGE(H7:H354)

 

[xargon]

Hi,

Excel has an AVERAGE function that you can use.

Hope it helps.

Panka

 

[confused man]

Thank you Peo, this is exactly what was looking for. Appreciate it!

Confused Man

 

[rodolform]

Hi:
Try
=AVERAGE(h7:H354)

Rd

 

[FDDavis]

you perhaps could use =average(h7:h354)
good luc