Trying to get Monthly Summary based on QTY per

Hi Team!!

Gosh I miss this place
Now that I am done buttering you all up, I have a relatively simple question that is yet again just outside my realm of skills and can't seem to solve this riddle without an array formula. Please see the attached excel document.

The data I have to work with is in columns A through J and the desired output is highlighted in yellow. What I want to do is take the monthly data in columns A:C and multiply it by the "QTY Per" in H based on 2 different things being product family (in column F) and model number (column J) to get the desired output on the right. I would imagine both formulas would be very similar.

Thanks in advance!

Originally Posted by benishiryo

hi ProudSmitty. try this in cell M4:
=SUMPRODUCT(($F$4:$F$6=$L4)*A$4:A$6*$H$4:$H$6)

and this in cell R4:
=SUMPRODUCT(($J$4:$J$6=$Q4)*A$4:A$6*$H$4:$H$6)

This works! I have tried to use a sumproduct on my own but it is difficult finding new ways to execute it. It truly is an extremely versatile function.


Thanks again