TOTALING ONE COLUMN FROM INFO IN ANOTHER

[JT]

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

 

[Bernard Liengme]

=COUNTIF(H1:H50,"+") tells how many
and
=SUMPRODUCT(--(H1:H5="+"),G1:G50) tell how much
best wishes

 

[Stephen]

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