Sumif help please

B

Barb1

I have 4 copiers with different prices per copy. I need to write a formula
with criteria to fit this.

Model Price per copy number of copies total price
490 .012 17
550 .32 211

So, I need if model #x then multiply by its corresponding cost.
 
S

Sandy Mann

Barb,
If I understand you correctly then with your table, Model, Price & Copies
in A1:C5 and the required model # in E1 then:

=VLOOKUP(E1,A1:C5,2)*VLOOKUP(E1,A1:C5,3)

will give the total price for the model.

HTH

Sandy
 
Top