I am trying to create a formula on a 'summary' sheet that will be the average
of the same cell on a series of 'detail' sheets. Using the AVERAGEIF formula
would appear to be the answer, but I get a #VALUE error when I put the
following formula in the Summary cell

=AVERAGEIF(Sheet1:Sheet8!D12,"35")

Any thoughts, ideas, suggestions??

Thankds