group product and sum across rows and columns

[Michaelbbeck]

Hi Guys not sure how to phase this (attached a file)

I have two rows
Price and qty

I want to add up the qty - easy

but in the formula i want to directly calculate the total price for all items without having to do it individually. That is, I want to multiply A2 * C2 down cells 2 to 15 and have the sum the entire in c30, and I want to do this for each month c2 to f2 etc.

there are up to 100 columns

Appreciate any help.

Michael

 

[Michaelbbeck]

got it

its sumproduct

thanks all