multiply countif outcome

[janbaetens]

Hi everyone.

I'm new to this forum.

I tried searching for my "problem" but don't really know what to look for.

I made an excel file to count how much clothing employers need. Everything works fine until i want to make a "Total per clothing size".
If everyone would order just one of each, there wouldn't be a problem. But now the outcome of my "countif" formula has to be multiplied by the numbers in front of the "x".
Hope this is possible with excell.

I hope you guys understand what i'm going for

Thanks!!

[samba_ravi]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[janbaetens]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks! Edited original post!

[63falcondude]

Hello and welcome to the forum.

Try this in R7:

=SUMIF($D$3:$D$15,R6,$B$3:$B$15)

[janbaetens]

NICE!!!

Thank you very much!!!!

[janbaetens]

Ok, one more question:

If i add something in one of the "extra clothing" collums, i want it to add up in the "Total per size" aswell...

[janbaetens]

Nevermind, got it!!

[63falcondude]

You're welcome. Happy to help.