Formula to Condense

[The Exceller]

Anyone Who Can Help:

I have a formula that is much too long which takes into account the quantity of a product that potential customers could buy and the price of each product.

I know there is a way of shortening and condensing the formula I currently am using which is what I need.

The current formulas goes through 17 different product categories and then multiplies the price by the quantity.

I.E.-- sum((A1*B1),(D1*E1),.....) The "...." goes out for 17 different products on the sheet.
This is where A1 is the Quantity and B1 is the Price of the first product, D1 is the Quantity of the second product and E1 is the price of the second product.

Attached is the spreadsheet for easier explanation. The formula I'm searching for needs to be in column EJ.

Any help is appreciated.

[DonkeyOte]

You could use an Array

Please Login or Register  to view this content.

or a SUMPRODUCT

Please Login or Register  to view this content.

no more efficient (really) but no Array entry required

(obviously it would be easier to have a cost per product - as per Paid)

[The Exceller]

Awesome! Thanks DonkeyOte.