Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column C for duplicate account number in Column A
Use SUMIF() .Replace the text string to a cell reference.
=SUMIF(A:A,"Account A",C:C) If this post helps click Yes --------------- Jacob Skaria "Melody" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column C for duplicate account number in Column A
Thanks Jacob. That doesn't quite take care of the issue. As indicated
below, I have a long list of Accounts in Column A so I cannot use "Account A" in the formula . I need something that will look at all the different accounts in the Column A, identify the Accounts (rows) that match and then add up the amounts in Column C that match those rows Account in Column A. Hope this makes it a little more sense. "Jacob Skaria" wrote: Use SUMIF() .Replace the text string to a cell reference. =SUMIF(A:A,"Account A",C:C) If this post helps click Yes --------------- Jacob Skaria "Melody" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column C for duplicate account number in Column A
Sounds like you need to make a unique list using datafilteradvanced
filter 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 "Don Guillett" wrote in message ... Look in the help index for SUMIF. Should be able to do it using col a as the criteria for col c total -- Don Guillett Microsoft MVP Excel SalesAid Software "Melody" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Column C for duplicate account number in Column A
Use the subtotal option under the Tools menu. Sort your data by Column A and
using the subtotal option, tell Excel to sum Column C at each change of column A. "Melody" wrote: 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. |
#9
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 |