I have figured out the formula to get the sum from 31 sheets on to a summary
sheet at the end of the Excel book; EX: =SUM(1:31!J3:J8). However, I now need
to know how to do it with an exception. Ex: I need =SUM(1:31!P3:P4) BUT ONLY
IF J3:J4 IS POPULATED + (1:31!P5:P6) BUT ONLY IF J5:J6 IS POPULATED +
(1:31!P7:P8) BUT ONLY IF J7:J8 IS POPULATED. I need to put this all in to one
formula.