"JT" wrote in message
...
Working with Excel 2003.

Have a spreadhseet that has individual contributions from members in
column
G and a "+", "-" or "0" in column H indicating if each person's
contribution
was more, less or the same as the previous year. I want to total the
contributions by each category. For example, if I have 50 members that
increased their contribution (would have a "+" in the column to the right
of
their each amount) I want to total the dollar amounts for just those
individuals. Ditto with those who decreased "-" and those who remained
the
same "0".

Can you help with the function or formula?

Thanks!

JT

Something like
=SUMPRODUCT((G1:G1000)*(H1:H1000="+"))