I'm using Excel to manage the contacts for organization my company is partnered with. Each organization (Column A) is listed multiple times (multiple rows for each organization; one row for each individual contact person we have for that company).
I want to have a running "total members represented by our partner organizations" cell at the bottom of Column B. A simple sum won't work, because it adds up all the values in the column, and I just need it to add each organization's membership number once. (So only 10,000 for ABC organization, not 30,000).
So, the correct sum for total number of members across all organizations in this sample table is 41,000. A simple sum of Column B gives a total of 86,000.
How do I do this?!
I want to have a running "total members represented by our partner organizations" cell at the bottom of Column B. A simple sum won't work, because it adds up all the values in the column, and I just need it to add each organization's membership number once. (So only 10,000 for ABC organization, not 30,000).
So, the correct sum for total number of members across all organizations in this sample table is 41,000. A simple sum of Column B gives a total of 86,000.
How do I do this?!
| Organization Name | Members | Association Type | Contact Name |
| ABC | 10,000 | Type 1 | John |
| ABC | 10,000 | Type 1 | Beth |
| ABC | 10,000 | Type 1 | Mike |
| DEF | 5,000 | Type 3 | Fred |
| DEF | 5,000 | Type 3 | Allan |
| MNO | 20,000 | Type 8 | Robert |
| MNO | 20,000 | Type 8 | Gina |
| PQR | 5,000 | Type 2 | Peter |
| VWX | 1,000 | Type 5 | Charlie |