Thread: Sum Column C for duplicate account number in Column A
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Scossa Scossa is offline
external usenet poster
  
Posts: 26
Default Sum Column C for duplicate account number in Column A
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 QuoteReply With Quote