sum like cells in a ticket

**95marine** · 12-26-2012, 01:56 PM

I have a ticket process that I am trying to clean up. I work for a oil field cement company that pumps similar materials in different cement slurries. Currently, they show up as different line items depending on the number of slurries I run. I have attached an example ticket where I ran several sacks of Class H cement with fluid loss, retarder and silica flour. I ran four different slurries so all four items show up four seperate times on my ticket. I would like for all of Class H to be added together, all fluid loss added together etc...

**JBeaucaire** · 12-26-2012, 02:27 PM

You can use SUMIF() for this. For instance, on Sheet2, put the matching words Fluid Loss in A2. Then this formula in B2:
=SUMIF(Sheet1!C:C, A2, Sheet1!P:P)

Then put Silica Flour in A3, and copy B2 down...

Etc. Remember that the codes on sheet2 you put in column A should be an exact match for the text strings in Sheet1 column C.

**rcm** · 12-26-2012, 02:29 PM

I placed the requested summary in sheet2

**95marine** · 12-26-2012, 03:16 PM

That certainly got me started in the right direction. However, the information on my ticket pulls from a Data Bid Sheet, which I included in this spreadsheet. It is summing correctly but I don't know how to get the items to only appear once on my ticket. It will sum like materials but the materials still appear on my ticket 4 times and are charged 4 times more than the actual cost.