SUM cells in column based upon criteria in two others.

J

JT

Can not seem to put together a formula that accomplishes the following:

Column J contains contributions by individuals for 2010
Column I contains contributions by individuals made in 2009
Column N contains an indicator (+ - or 0) of the increase or decrease over
the two years
Column P contains a designation of which members are new members.

I need a formula that looks at column I cells against column J cells, totals
the contributions made be each of the criteria in column N, but does NOT
include those with any designation in column P. Example of the data:


I J N P
2009 2010 INC/DEC NM

900 1,200 + NM09-3

I'd appreciate ANY help!

Thanks! JT
 
F

Francis

Hi

does this do what you want? try this in column N

=IF(AND(J2>I2,P2=""),"+",IF(AND(J2<I2,P2=""),"-",""))
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis
 
L

LovesAChallenge

A simple formula that might do what you want is:

In the N column, type:

=If(N2,"-",SUM(J2-I2))
*NOTE: N2 refers to column N, row 2. Use the applicable column/row
information. Once you have keyed this formula into the first cell/row under
column N, copy and paste it down the column as needed.

Let me know if this works for you.
 
L

LovesAChallenge

Sorry - correction to that formula; instead of "N2", it should have read
"P2". Sorry for any confusion.
 
J

JT

Francis:

Thanks for the try but what I am looking for is a formula that does what I
outlined but SAUMS the entire column based upon the criteria I outlined, not
the row.

Does that make any sense?
 
J

JT

Unfortunately what I need to formula to do is SUM the column (and all entries
in it) based upon the crioteria that I outlined. So the total would be in
one cell at the bottom of the column.

Does that make any sense?
 

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