TOTALING ONE COLUMN FROM INFO IN ANOTHER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=COUNTIF(H1:H50,"+") tells how many
and
=SUMPRODUCT(--(H1:H5="+"),G1:G50) tell how much
best wishes
 
JT said:
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
Click to expand...

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