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