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

SUM and COUNT both ranges to see if you're dealing with different data sets.

Dave
--
Brevity is the soul of wit.


"jmj713" wrote:

I have an interesting problem. In my spreadsheet I have two averaging cells.
The first [=IF(COUNT(B2:B191)=0,"",AVERAGE(B2:B191))] averages a column of
clients' visits and gives out an average number of visits per month. In
January of 2005 this number is 13. The second cell
[=IF(COUNT(N2:N191)=0,"",AVERAGE(N2:N191))] averages a column with identical
numbers, a yearly total column, and gives out an averages for the year. I
only entered data for one month, so I was expecting to see 13 in both cells.
But the second cell returned 12. How is that possible?