Horizontal Sum Product

Good Afternoon All

I have attached an excel file to illistrate

I am wanting to sum the product of several pairs of columns to a cell right at the end. The problem is when i need to add more pairs of columns (Stock 4, Stock 5, Stock 6) etc, it will become extremely painful to add. I feel that a SumProduct is the way to go, however i cannot see how to get it to work in this situation.

I would appreciate any assistance to make the resulting formula easier to program when adding additional stocks will be easier.

Thanks in advance.

Try

=SUMPRODUCT(($D$3:$H$3="Units")*$D5:$H5*$E5:$I5)

Thank you. both work like a charm

You're welcome.