| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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="+")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Totaling a Column of Numbers | Excel Discussion (Misc queries) | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| Formula for totaling column | Excel Worksheet Functions | |||
| Totaling up a column | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Hybrid Mode
