Searching for 2 values and returning the sum...

L

leekesm

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?
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top