.... and F8:F39 is 32 cells, Ron, so perhaps F9:F38 or F10:F39 for 30 cells?

It is also worth remembering that AVERAGE will ignore blank cells or cells
with non-numerical contents, whereas SUM()/30 will divide by 30 regardless
of how many cells have numerical contents so effectively treats the other
cells as having a number zero rather than excluding from the averaging.
--
David Biddulph

"Ron Coderre" wrote in message
...
Have you tried the AVERAGE function?

Example:
=AVERAGE(F8:F39)

(Note: F9:F39 is 31 cells)


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Christopher" wrote:

I want to select a range of cells vertically arranged from F9:F39, and
divide
by 30 to average on any noted range of 30 days. Would the formula for
this be
(F9:F39)/30 ?
--
Christopher Herring