rolling averages

I am working on a spread sheet and am trying to use rolling averages of the last 3 months. I am using worksheets for each month with a final worksheet containing the 3 mo. rolling average. I tried using a formula with OFFSET and it worked fine if all the data was in 1 worksheet, but did not work for multiple worksheets averaging to another worksheet in the same workbook.

attached is a version of the spreadsheet I am working on for a rolling average.

If it is difficult to construct and attach an example workbook,
at least give us a precise example of one of your OFFSET() formulas.

From your original post it is impossible to work out what is wrong.

=AVERAGE(OFFSET('RIC - May'!D5,COUNT('RIC - May'!D5,'RIC - June'!D5,'RIC - July'!D5,'RIC - Aug'!D5,'RIC - Sep'!D5,'RIC - Oct'!D5,'RIC - Nov'!D5,'RIC - Dec'!D5)-3,0,3,1))

This is the formula I am using, honestly I am not sure about the final piece
"-3,0,3,1"

Attached is a zip file of the rolling averages problem. Any help would be appreciated!

[QUOTE=bradleyhanks]
=AVERAGE(OFFSET('RIC - May'!D5,COUNT('RIC - May'!D5,'RIC - June'!D5,'RIC - July'!D5,'RIC - Aug'!D5,'RIC - Sep'!D5,'RIC - Oct'!D5,'RIC - Nov'!D5,'RIC - Dec'!D5)-3,0,3,1))
QUOTE]

The COUNT() will give you the number of of sheets that have entries in D5.
So you are taking the average of 3 cells from column D of the sheet called 'RIC - May',
These three cells are offset relative to the cell 'RIC - May'!D5 by several cells.
This offset is equal to the number of of sheets that have entries in D5 minus 3.
I suspect this is not what you were intending...
Unfortunatly I can't open attachments from this forum, but if you can describe what you were intending, I might be able to help.

Ok, assuming I cannot do a rolling average amongst worksheets in a workbook like I would prefer, I do have another possible solution, but I am running into problems with it as well. I have added an "IF" statement to a cell that says
=IF(W1="May",AVERAGE('RIC - Mar'!$D$6,'RIC - Apr'!D6,'RIC - May'!D6),IF(W1="June",AVERAGE('RIC - Apr'!D6,'RIC - May'!D6,'RIC - June'!D6),IF(W1="July",AVERAGE('RIC - May'!D6,'RIC - June'!D6,'RIC - July'!D6),IF(W1="August",AVERAGE('RIC - June'!D6,'RIC - July'!D6,'RIC - Aug'!D6),IF(W1="September",AVERAGE('RIC - July'!D6,'RIC - Aug'!D6,'RIC - Sep'!D6)))))). This gives me a three month average, but to do a whole year I must use multiple cells. I then want the following experession to check each of the cells for data and if it has data and not a FALSE, to rank it. The forumula is: =IF(D5>=0.951,5,IF(D5>=0.901,4,IF(D5>=0.851,3,IF(D5>=0.801,2,IF(D5<0.801,0))))). How do I tell the cell to look at cell E5 if cell D5 delivers a FALSE, and to then rank it with the previous formula?

I think you are trying to use the OFFSET() function inappropriately.
As I see your problem the AVERAGE() needs three addresses that change according to the month.
I would probably approach this problem as follows:
Set up a list of the worksheet names along a row (or down a column)
select the first worksheet name and add on the rest of the text to make an address
either =A1&"!D5" or use the ADDRESS() function
repeat for the other two addresses, then:
=AVERAGE(INDIRECT(address1),INDIRECT(address2),INDIRECT(address3))
The key function is the INDIRECT() which will return the value from within a cell where the address is given in a text string.

I hope this helps.

Oops I forgot to attach the workbook.