Sumproduct - help

Hello,

I need to multiple line 1 (b4:q4) with line 2, but the price (in line 2) depend of month. The result is in cell s4.

Can you help me please.

Thanks

Populate S4 with the formula:

Please Login or Register  to view this content.

As shown in the updated version of your file:

Copy of excel.xlsx

Note: I added data validation to A4 so that you can easily change the month.

Let me know if you have any questions.

JeteMC,

Simply perfect!!!

Thanks