T
TPaton
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
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