I have just worked out that a formula I have been using is not working as I
thought. I am trying to 1) count a number of occurances of a certain risk
appearing, and 2) average them. I filter the data on Sheet1 and Sheet2 is a
reporting page where I do the calculations. I have tried:

Subtotal(1,$AA$5:$AA$992) -for average and subtotal(3,$AA$5:$AA$992) for
count.
AND
SUMPRODUCT(SUBTOTAL(1,OFFSET(Sheet1!$AA$5:$AA$992, ROW(Sheet1!$AA$5:$AA$992)-MIN(ROW(Sheet1!$AA$5:$AA$992)),,1)),--(???)

The question mark is where I come into diffculty. What do I say it equals? I
filter on column A which is a concatenate formula based on month and year.
Each time the report is retrieved it is for different months/years. Because I
made it for others to use, I can't just alter the formula each time.

Could someone help - quickly!!
Thanks