Need more help with a formula

[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.

 

[Jarek Kujawa]

positive:
=SUM(IF(1:31!P38>0,1:31!P38,))

negative:
=SUM(IF(1:31!P38<0,1:31!P38,))

these are array formulas that need tobe entered with CTRL+SHIFT+ENTER
instead of simple ENTER

HIH

 

[Eric]

I can not get those formulas to work

 

[Bob Phillips]

See my response in excel.misc

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Eric]

I found it and tried it, but I could not make it work.

 

[Bob Phillips]

Well I can assure that it does work.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[David Biddulph]

Well, one thing you are doing wrong is sending rather unhelpful replies (in
this group and on a similar thread in another group) like "did not work".
If you want someone to help you, you'll need to supply more detail. What
formula were you using, what data values went into that formula, what result
did the formula give you, and what did you expect?