View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Melody Melody is offline
external usenet poster
 
Posts: 51
Default Sum Column C for duplicate account number in Column A

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
.