Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column C for duplicate account number in Column A
Hopefully this makes sense. I have a huge spreadsheet that has different
account numbers in Column A, each of these accounts could have a different sub account in Column B. In Column C is the total number of items for each subaccount. What I'm trying to do is add up all the items per Account. The spreadsheet is too big to do a simple sum if Column C equals "Account A". It has to be a little more sophisticated than that but still as simple as possible. Column A Column B Column C Account A Account A1 5 Account A Account A2 5 Account A Account A3 12 Account B Account B1 10 Account C Account C1 5 Account C Account C2 3 So, total Column C for all Account A's = 22. Total for all Account B's = 10, etc. Again, I have a long list of accounts and I want a formula that will look at all the items in Column A and just total Column C for the rows that match in Column A. Hopefully that makes sense. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find duplicate cells in Column a & retrieve column B | Excel Discussion (Misc queries) | |||
Return Row Number of PREVIOUS Numeric Consecutive Duplicate in Column | Excel Worksheet Functions | |||
Count occurance of largest duplicate number in a single column ran | New Users to Excel | |||
How can I check for a duplicate number in a column in Excel? | Excel Discussion (Misc queries) | |||
Return Row Number of LAST Numeric Consecutive Duplicate in Column | Excel Worksheet Functions |