COUNTIFS, MULTIPLY BY QUANTITY
 

I have a spreadsheet for clothing order for a group of people. There are 8 different shirt types (tee, hoodie, etc.) and 10 different sizes available. I want to tally the number of shirts and sizes ordered. So I count the B column type, and C column size:
=COUNTIFS($B:$B,$H16,$C:$C,K$15)

The problem I am running into is that some families have ordered multiple quantities of the same thing (ex: adult XL tee-shirt, qty: 2). I have the quantity ordered in column D.

How do I search columns B and C for criteria, and when the right criteria is identified, multiply that by the quantity ordered?

COUNTIFS, MULTIPLY BY QUANTITY
 

Hi,

Am Tue, 9 May 2017 14:57:39 -0700 (PDT) schrieb
:

I have a spreadsheet for clothing order for a group of people. There are 8 different shirt types (tee, hoodie, etc.) and 10 different sizes available. I want to tally the number of shirts and sizes ordered. So I count the B column type, and C column size:
=COUNTIFS($B:$B,$H16,$C:$C,K$15)

The problem I am running into is that some families have ordered multiple quantities of the same thing (ex: adult XL tee-shirt, qty: 2). I have the quantity ordered in column D.

try:
=SUMPRODUCT(--(B1:B1000=H16),--(C1:C1000=K15),D1:D1000)


Regards
Claus B.
--
Windows10
Office 2016

COUNTIFS, MULTIPLY BY QUANTITY
 

That worked like a champ! Thanks.