Count certain values

R

Ray

I have a spreadsheet that has column A with names, column B with their
choice of meal.
Example:
A B
John Steak
Bill Chicken
Joe Salmon
May Steak
Jean Chicken
What I want to do is count how many of each dish are required (how many
steaks, chickens to order)
Can someone please show me the formula?
Thanks
 
R

RAGdyer

Probably the easiest way would be to create a "master, unique" list of all
available meals, say in Column C.
Then, with names and choices filling A1 to B100, try this in D1:

=Countif(B1:B100,C1)

And copy down as needed.
 

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

Similar Threads

Compare 2 lists and return value 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Vlookup but with multiple results 22
Counting unique values in column 3
aconcat UDF throwing a #NAME error 10
Data sorting automatically? 10
displaying multiple inputs 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top