 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Count certain values
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 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.  SignatureHTH, RD ---------------------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! ---------------------------------------------------------------------------------------- >I have a spreadsheet that has column A with names, column B with their >choice of meal. [quoted text clipped - 9 lines] > Can someone please show me the formula? > Thanks =Countif($B$1:$B$100,C1) SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Probably the easiest way would be to create a "master, unique" list of all > available meals, say in Column C. [quoted text clipped - 16 lines] >> Can someone please show me the formula? >> Thanks Yes ... forgot that ... didn't I?<bg> SignatureRegards, RD ---------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------------- > =Countif($B$1:$B$100,C1) > [quoted text clipped - 18 lines] >>> Can someone please show me the formula? >>> Thanks Wait till you get to be my age and forget everything. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Yes ... forgot that ... didn't I?<bg> >> =Countif($B$1:$B$100,C1) [quoted text clipped - 19 lines] >>>> Can someone please show me the formula? >>>> Thanks Bet I'm *past* your age! Nov. '38 SignatureRegards, RD ---------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------------- > Wait till you get to be my age and forget everything. > [quoted text clipped - 21 lines] >>>>> Can someone please show me the formula? >>>>> Thanks Send the Wild Turkey 101 to me April 15 (income tax day) 1936 SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Bet I'm *past* your age! > [quoted text clipped - 25 lines] >>>>>> Can someone please show me the formula? >>>>>> Thanks Well ... 2 years probably worth 2 bottles ... I owe ya! SignatureRegards, RD ---------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------------- > Send the Wild Turkey 101 to me > April 15 (income tax day) 1936 [quoted text clipped - 28 lines] >>>>>>> Can someone please show me the formula? >>>>>>> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.