averaging across worksheets

[rickeye]

I have a workbook with twelve worksheets, one for each month. Each sheet has the same set-up for cells, just different data for each cell for each month. I would like to average the value for each cell across the twelve months. For example, one month C3 may have a value of 10, next month 12, and so on. I need to know what the average for C3 is over the entire year. Then, I would move on to the average for C4 across the twelve months. Ideally, I could just average all the respective cells for the whole sheet at once with one formula, but if I have to go through cell by cell to put in a formula for each one I will. Any ideas on how to do this? I would think this should be fairly standard stuff for business calculations, but I cannot find any instructions on how to do it.

Thanks.

[cvolkert]

I think the following will do what you want. In formula, change Sheet1 to the left most tab name, Sheet2 to the right most tab, and A1:A2 to the range you want included on each sheet. It will average for all tabs between the two sheets. Hope this helps - Chad

=AVERAGE(Sheet1:Sheet2!A1:A2)

[rickeye]

OK, that does work, though for averaging across sheets 3 through 1 for cell c3, I actually put in =average(3:1!c3) and that works. Thanks. Do you know of anyway to do that for the whole sheet of cells rather than plugging in the formula into each cell individually? For example, I have data on a sheet from C3 to L36 that need to be averaged with their counterparts on the three worksheets. I'll do it, but if there is an easier way to get it all done in one fell swoop....

Thanks.