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:P8) BUT ONLY
IF THE FIGURES IN P3:P8 ARE POSITIVE.
Then I need, for another cell, =SUM(1:31!P3:P8) BUT ONLY IF FIGURES IN P3:P8
ARE NEGATIVE.