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.

Sum Column C for duplicate account number in Column A
 

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.

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.

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.

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.

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

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
.

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.

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
.