change your quarterly averages to use

=Subtotal(1,monthly cells)

and your annual average to

=Subtotal(1, all cells)

The subtotal() function will ignore any other subtotal() formulas in the
range, and appears to ignore empty cells, too



"HARSH BAHAL" wrote:

I have in a row (adjacent coloumns)months & quarters (Jan, Feb, March,
quarter 1...upto Quarter 4 and then year total). I want to calculate the
annual average ignoring the quarter figures and the blank cells also. Pl help