View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JT JT is offline
external usenet poster
 
Posts: 234
Default 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