Your formulas work correctly for me--both return the same average. I repeat
my earlier suggestion: SUM and COUNT both ranges to insure that you are, in
fact, dealing with the same data sets in both ranges.

Also check to see if calculation is set to automatic:
Tools--Options--Calculation

Dave
--
Brevity is the soul of wit.


"jmj713" wrote:

You're averaging different ranges of data. Does either range have different
data?

They are different ranges but the data is the same. In the first column is
the number of a client's visit for that month. The other column in a yearly
total. The two cells average the two columns respectively, but since I only
entered a month's worth of data, the data in the first column (January) and
the data in the last column (Yearly Total) is the same. The two functions
average those two columns, and, to my understanding, the should be the same,
unless I'm missing something, or very confused.