If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Searching for 2 values and returning the sum...
I quite often have this problem, and I have never come up with a solution...
In this example I have customers coming to our restaurant at Christmas. We have food orders for each customer. I want to be able to look for all the customers sat on table 1 (in one column) and count how many people want (for example) soup (in another column). Any obvious functions I am missing? |
#2
|
|||
|
|||
Searching for 2 values and returning the sum...
Sumproduct could be used, I believe.
Something like this In D2: =sumproduct((b2:b100="Table1")*(c2:c100="Soup")) will count the number of occurrences of "Table1" in col B with "Soup" in col C -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "leekesm" wrote: I quite often have this problem, and I have never come up with a solution... In this example I have customers coming to our restaurant at Christmas. We have food orders for each customer. I want to be able to look for all the customers sat on table 1 (in one column) and count how many people want (for example) soup (in another column). Any obvious functions I am missing? |
#3
|
|||
|
|||
Searching for 2 values and returning the sum...
SUMPRODUCT
-- David Biddulph "leekesm" wrote in message ... I quite often have this problem, and I have never come up with a solution... In this example I have customers coming to our restaurant at Christmas. We have food orders for each customer. I want to be able to look for all the customers sat on table 1 (in one column) and count how many people want (for example) soup (in another column). Any obvious functions I am missing? |
Thread Tools | |
Display Modes | |
|
|