In article , Peo Sjoblom
writes
If you change the formula that returns the zeros if they are blank then the
average formula should work

For instance

=IF(A2="","",A2)

would return a blank and Pete's formula would ignore that cell but if you
use

=A2

where A2 is blank then that cell returns zero and will be included

Another way assuming that the monthly totals can never be zero


=SUM(D4:D16,I4:I16)/(COUNTIF(D4:D16,"0")+(COUNTIF(I4:I16,"0")))



HI

OK thanks for that. I have used the second formula you suggested and
this work perfectly - thanks!



Best Wishes


Colin