First off, your range F9:F39 is actually 31 cells, not 30. So, dividing by
30 would not give you a true average.

That being said, to determine the average of a range, you can use the
AVERAGE function.

=AVERAGE(F9:F39)

This is effectively the sum of a range, divided by the count of a range. Or:

=SUM(F9:F39)/COUNT(F9:F39)

HTH,
Elkar


"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