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