| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply value based on quantity | Excel Worksheet Functions | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
| excel multiply by different values based on quantity | Excel Discussion (Misc queries) | |||
Threaded Mode
