SUM cells in column based upon criteria in two others.

[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

 

[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

 

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

 

[LovesAChallenge]

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

 

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

 

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