Take a look at SUMIF funciton in help....

"Brad Delit" <Brad wrote in message
...
Hello

This is what I am trying to do?

I simply want to Excel to locate and sum all of the dollar amounts that
match numbers that I have on another tab. For instance!

On Tab A.

Column Heading's Location No. Grand Total
1225
$$$$.$$
1250
$$$$.$$

On Tab B.
Column Heading's Location No. Total
1000
25.00
1225
2000.00
1250
2500.00
1225
5874.00
1300
6000.00
1250
7851.00

For instance the column on Tab B has hundreds of location No.'s I simply
want to sum up all of the same location No.'s on Tab A, can you help me.

Thank you once again for your time.