Thread: COUNTIFS, MULTIPLY BY QUANTITY
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote