Help with Lookup formula

[Graham]

I have a three columns of data, column A has part number, column B has cost,
column C has company name. What I would like to be able to do is for a
formula to lookup 'company1' and give me a total cost of the parts.

Is this an easy thing to do?

 

[KL]

Hi Graham,

Try this:

=SUMIF(C1:C10,"company1",B1:B10)

Regards,
KL

 

[Graham]

Many thanks, that has worked fine.

Hi Graham,

Try this:

=SUMIF(C1:C10,"company1",B1:B10)

Regards,
KL