avg A B C D
1 91 ****** 91 91 91 91
2 89 89 89 89 89
3 78 78 78 78 78
4 65 65 65 65 65
5 77 77 77 77 77
6 68 68 68 68 68
7 86 86 86 86 86
8 89 89 89 89 89
9 95 95 95 95 95
10 #DIV/0! #DIV/0!
11 #DIV/0! #DIV/0!
12 #DIV/0! #DIV/0!

AVG #DIV/0! (THIS IS A MONTHLY AVERAGE)

****** = SUM OF COLUMN A WHICH IS THE AVERAGE OF COLUMNS B TO D

Can I get the current monthly average without having to post all of the
months results, that is, the average without the months that have "DIV/0"
which would be 82?
Many thanks for your help!!

"curlydave" wrote:

what is the formula you are using right now?
teacher1 wrote:
I am a very basic XL user, but I work with spread sheets using the simple AVG
formula. Is there any way to by pass the "0" in DIV/0? in other words, I am
using 4 columns of numbers that were each averaged. There is another column
with the average of the 4 separate columns, but I get the "DIV/0" unless all
4 of the other colums have a base larger than "0". In other words do I have
to wait until all 4 coulms are completed before I can determine the on going
average, or is there a formula or way to get the averages of the columns that
do not have a zero base and not have to wait until all 4 colums have a base
larger than zero?