Thread
:
Count certain values
View Single Post
#
7
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
Count certain values
Send the Wild Turkey 101 to me
April 15 (income tax day) 1936
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RAGdyer" wrote in message
...
Bet I'm *past* your age!
Nov. '38
--
Regards,
RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------
"Don Guillett" wrote in message
...
Wait till you get to be my age and forget everything.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"RAGdyer" wrote in message
...
Yes ... forgot that ... didn't I?<bg
--
Regards,
RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------
"Don Guillett" wrote in message
...
=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