Sumif help please
 

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.

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

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Barb1" wrote in message
...
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.