=SUMIF(A:A,200,B:B)
OR
=SUMIF(A:A,<ReferenceCell,B:B)

If this post helps click Yes
---------------
Jacob Skaria


"LaDonna Brooks" wrote:

Is there a formula where you could do the following:

1A 200, 1B 25,000

2A 201, 2B 30,000

3A 202, 3B 10,000

4A 200, 4B 15,000

5A 201, 5B 5,000

6A 200, 5B 12,000

Can you have it total everything in Cell A with like codes? Is there a way
if the codes are the same in CellA €“ could it add 1A (25,000), 4A (15,000),
6A (12,000)? Thanks,


--
msladona