Actually, it looks like there is, but I'm not sure what is in your cells. If
the worksheet is laid out like this
A B
1 200 25000
2 201 30000
3 202 10000
4 200 15000
5 201 5000
6 200 12000

Then a formula like =SUMIF(A1:A6,"=200",B1:B6) should work.


"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