Average the source data and not the averages. Note that averges of averages
can get a little troublesome depending what you want to do.
=average(B2:F4)

If you have 100 values of 1 it's average is 1.
If you have 1 value of 100 it's average is 100.
Average of Averages is (1 + 100) / 2 = 101 / 2 = 50.5
Total average is (1+1+1+... + 100) / 101 = 200/101 = 1.98

Obvioulsly not the same...
--
HTH...

Jim Thomlinson


"Scott R" wrote:

Him You Them Us Me
12 10 8 6
12 11 7 4
11 9 6 9
average 11.6 10 7 6.3 #DIV/0!

How can you average the cells in the bottom row and ignore the #div/0! Error
to get the answer 8.76?