Thread
:
Sum Column C for duplicate account number in Column A
View Single Post
#
9
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett