TOTALING ONE COLUMN FROM INFO IN ANOTHER
 

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

TOTALING ONE COLUMN FROM INFO IN ANOTHER
 

=COUNTIF(H1:H50,"+") tells how many
and
=SUMPRODUCT(--(H1:H5="+"),G1:G50) tell how much
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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

TOTALING ONE COLUMN FROM INFO IN ANOTHER
 

"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="+"))