Conditional Summing in Excel 2000

[LimitedTech]

I would like to sum cells if another cell matches.

For example, I have a sheet with 100 rows.
Column A is 5 digit id number. Any number of these can match each other. If they match they will be in consecutive rows.

Column B is a currency amount.

If the numbers in column a match I would like column C to contain a sum of those items.

Something like this:

A B C
00001 $1.00
00002 $2.00
00002 $3.00 $5.00
00003 $1.00
00004 $1.00
00004 $5.00
00004 $9.00 $10.00

I am not sure how to do this since column A could have any number of matches to include in the sum.

 

[SkipVought]

Hi,

Check out Data > Subtotal... or Data > PivotTable report...

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[LimitedTech]

Thanks! That's What I needed.