Monday, December 23, 2013

yogi_Compute Quantities Ordered By Product Number And Color Given The Order Number

                                          Google Spreadsheet   Post  #1442
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-23, 2013
question by Villu (https://productforums.google.com/forum/#!topicsearchin/docs/after$3A2013$2F11$2F30$20AND$20-is$3Aduplicate$20AND$20-is$3Aanswered$20AND$20-is$3Aresponded$20AND$20-is$3Acanbeignored%7Csort:date%7Cspell:true/docs/qR6wF92Xr4I)
how to sum values that meet 3 criteria
Hi

I need some help with my spreadseet. I have a table of product orders where every order has unique order number, order date, order deadline, client name, status of order and product info. Product info consists of product name, color and quantity. There are 18 different combinations of products and colors (6 products and 3 colors).

I use data validation to enter client name, product name and color to avoid typos.

I other table I have the summary of orders where I have entered all the combinations of products and colors and need to know how many of these combinations has been ordered. For example, how many Red Product 1 has been ordered by all clients in total. I tried index and match, but it gives me the first match as result and does not sum the matches.

In addition to that I have a table for summary of one order (order sheet). There I need to find quantities of all product name and color combinations that match order number.

I hope my description of a problem is understandable and someone can help me.

Thank you in advance,
Villu
---
-------------------------------------------------------------------------------------------------------------------------------