How to sum values according to an accounting code

[IanTr]

Hi folks

I have an accounting spreadsheet which has, as one of its columns, a 3 character accounts code. Another column holds the value associated with this code. For example, column A holds the account code and column B the value:

ES2 $4.30

I'm looking for a formula, please, which can scan the whole sheet, find all values with a specific account code and place the total in another cell. I have about a dozen account codes, so I would create a list of those codes with the total of the values for each code placed next to it e.g.

ES2 $123.40
ES3 $75.60

So I need the formula which would go where $123.40 is located, and so on.

I have no idea where to start, so I would appreciate any help that anyone can give me.

Many thanks

Ian T

 

[MARK858]

Seems like a simple SUMIF as long as they are real numbers formatted as currency rather than text, so where C2 holds the accounts code to look up. In D2...

=SUMIF(A:A,C2,B:B)

Excel 2010
	A	B	C	D
2	AC1	372	AC1	818
3	AC2	144	AC2	382
4	AC3	145	AC3	145
5	AC4	370	AC4	370
6	AC1	166
7	AC1	280
8	AC2	238
Sheet2

Cell Formulas
Range	Formula
D2	=SUMIF(A:A,C2,B:B)
D3	=SUMIF(A:A,C3,B:B)
D4	=SUMIF(A:A,C4,B:B)
D5	=SUMIF(A:A,C5,B:B)

 

[IanTr]

Thanks, Mark. Just to clarify, each entry is on a separate row, the account codes are mixed up, so they could be like this:

AC1
AC2
AC1
AC3
AC4
AC3
AC1

etc. Would your method scan the whole worksheet looking for a specific code and then dump the sum of the associated values into a cell?

 

[MARK858]

Does the table I posted not already show that? See AC1 in the table I posted. It looks up in column A as per...

For example, column A holds the account code and column B the value:

 

[IanTr]

Hi Mark.. sorry, this really works. So thankful to you. You've no idea how much work this has saved me!

 

[MARK858]

Happy it helped and welcome to the forum.