Formula too long

Could you please help me to reduce the formula:

=(A2=sheet2!A3)*sheet2!I3+(A2=sheet2!A4)*sheet2!I4+(A2=sheet2!A5)*sheet2!I5+(A2=sheet2!A6)*sheet2!I6+(A2=sheet2!A7)*sheet2!I7+(A2=sheet2!A8)*sheet2!I8+(A2=sheet2!A9)*sheet2!I9+(A2=sheet2!A10)*sheet2!I10+(A2=sheet2!A11)*sheet2!I11+(A2=sheet2!A12)*sheet2!I12+(A2=sheet2!A13)*sheet2!I13+(A2=sheet2!A14)*sheet2!I14+(A2=sheet2!A15)*sheet2!I15+(A2=sheet2!A16)*sheet2!I16+ ......+(A2=sheet2!A60)*sheet2!I60

Originally Posted by zbor

Maybe this:

=SUMPRODUCT(--(sheet2!A3:A60=A2);sheet2!I3:I60)

Here is my problem:

I have 2 sheets:

sheet 1 where:
in column A I want to choose from a drop-down list the products
In column B I want to appear the price of the chosen product

Sheet 2 contains on column A all the products and on column I the prices for each product.

It works with IF formula :=IF(A1=sheet2!A3,sheet2!I3,IF(A1=sheet2!A4,sheet2!I4,IF ..............0)) but the formula is too long.

It is obvious that I am novice.
Thank you.

Originally Posted by daddylonglegs

...or SUMIF for a single criterion, i.e.

=SUMIF(sheet2!A3:A60,A2,sheet2!I3:I60)

Thank you. That I was looking for. Problem solved!