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 ?