|
Count 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 |
Count certain values
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 |
Count certain values
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 |
Count certain values
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 |
Count certain values
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 |
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 |
Count certain values
Well ... 2 years probably worth 2 bottles ... I owe ya!
-- Regards, RD ---------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------------- "Don Guillett" wrote in message ... 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 |
| All times are GMT +1. The time now is 07:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com