How to sum List items and separate column values into new worksheets.

[JoelBooth]

Hey guys, thanks for having me.

Ok heres where I have become stuck:
I am creating a Spreadsheet for budget managment and also to account for repairs on machinery, what I am looking to do is.

I have a dropdown bar of machines in column C and Price value for repairs in column H,
What I want to do is find a way where on a seperate sheet I can just List the machines and get a total cost for that individual item.

eg:
Column C Column H
Mach 1 £121
Mach 2 £155
Mach 3 £139
Mach 2 £966
Mach 1 £20,000
Mach 1 £49.25

Now remember column C is a dropdown bar, how do I total the values on another sheet to read the total per machine?

Thanks.

From the most confused person I know

[StephenR]

A pivot table perhaps.

[JoelBooth]

After a long shift last night I dont think the problem I posted made much sence.
try this:

What I want is the Sum of column H, but only from the values (which are in list form so therfor changable) where those values are in that row.

Also I dont know a great deal about the formula of excel so could you please explain what a pivot table is, Im willing to give anything a go.

I will link the excel file so you can see what I am trying to do maybe someone could have a look and see how I populate my Overview tab with the correct costs from the months for each individual machine.

[StephenR]

If you changed the sheet names or row 2 headings so that they matched, you could try this in C3 and copied down and across:

=SUMIF(INDIRECT(C$2&"!C:C"),$B3,INDIRECT(C$2&"!H:H"))