Sum by Style

Hi all,

Please help me to sum quantity of style as follows:

Please Login or Register  to view this content.

I need a formular to count as follows:
- Style A : 48*4 + 19*6 + 6*5 + 1*5 = 341 pcs
- Style B : …

Thanks

I don't think this is a VBA question, is it?

The correct formula answer is greatly affected by your sheet layout. Attach a sample workbook.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.