I have a workbook of about 30 pages.
I am trying to make a formula that will look at the same cell on each page
and if that cell has a value of "1" to sum another cell on only the pages
with the value "1".
I have tried, Sumproduct, Sumif, and have tried both of these with the
ThreeD function as well. I keep getting a VALUE error. Any suggestions?