Thread
:
Count certain values
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
Count certain values
=Countif($B$1:$B$100,C1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RAGdyer" wrote in message
...
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.
--
HTH,
RD
----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------
"Ray" <I ate
wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett