LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find duplicate cells in Column a & retrieve column B ghost Excel Discussion (Misc queries) 2 February 22nd 09 05:39 PM
Return Row Number of PREVIOUS Numeric Consecutive Duplicate in Column Sam via OfficeKB.com Excel Worksheet Functions 3 August 31st 07 09:21 PM
Count occurance of largest duplicate number in a single column ran catpro New Users to Excel 5 January 21st 07 05:10 PM
How can I check for a duplicate number in a column in Excel? kkinner Excel Discussion (Misc queries) 2 August 24th 06 03:44 PM
Return Row Number of LAST Numeric Consecutive Duplicate in Column Sam via OfficeKB.com Excel Worksheet Functions 10 July 7th 06 04:18 AM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"