Need more help with a formula

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!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.
 
J

Jarek Kujawa

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

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

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

HIH
 
B

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)
 
B

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)
 
D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top