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.