Aspiring Bean Counter.
Join Date: Feb 2006
Location: Howard Johnson's Earthlight Room
You're on the right track. Create cells to the side of the table that have all of the different values in them. Well call that cell C2 for now.
C2 would have the data "006129098"
Formula should be:
SUMIF(Range of cells of service ID, C2 (the criteria you want it to meet), Range of cells for dollar amount)
So if all of you service cells were in column A starting at A2 and your dollar amounts were in column B starting at B2, you would have:
SUMIF(A2:A17000, C2, B2:B17000)
I hope that makes sense and I hope it works.