Have a look in Help for "3D formula"
SUMIF is not in the list of functions that work with 3D references

This works
SUM((Sheet1!D8=101)*Sheet1!M13+(Sheet2!D8=101)*She et2!M13+(Sheet3!D8=101)*Sheet3!M13)
Type
SUM((Sheet1!D8=101)*Sheet1!M13+
the copy/paste and modify to complete the formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"medestar" wrote in message
...
I have several sheets in a workbook. I am using the first page (other than
the summary sheet at the very front) as page1, the last page is page3. I
am
trying to add the numbers in a specific cell (m13) from each page if
another
cell has specific criteria (d8=89). here is the formula I am using:

=SUMIF(Sheet1:Sheet3!D8,101,Sheet1:Sheet3!M13)

however, I keep getting the #VALUE! error message. I cannot figure out
where the error is. ANy help ?