creating a simple formula for a range of cells

C

Christopher

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 ?
 
E

Elkar

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
 
R

Ron Coderre

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
 
D

David Biddulph

.... 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.
 
Top