| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column C for duplicate account number in Column A
Sounds like you would like a macro to do this.
If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Melody" wrote in message ... Thanks but that's not what I'm looking for. I have a massive spreadsheet and I'm trying to do some compares. But I first need to find a way to sum up the amounts in Column C for Accounts in Column A without having to use "Account A" in the formula. "Scossa" wrote: On 4 Nov, 14:52, Melody wrote: 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 USe a PIVOT Table Bye! Scossa . |
| Reply |
| 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 | |||
Hybrid Mode
