| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
![Ray[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
