Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to insert a counter for supplies ordering.
I am creating a list of students that will be served lunch for the following
month at my school. They have two choices of lunches. Red or Blue. By their name the input of R or B is placed under the date. I need to count the number of R's and B's so I can know how much of each lunches I have to buy for? Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to insert a counter for supplies ordering.
The following assumes the R's and B's are in the range A1:A100, change this
to fit your data: For Red's: =COUNTIF(A1:A100,"R") For Blue's: =COUNTIF(A1:A100,"B") -- Regards, Dave "Phil" wrote: I am creating a list of students that will be served lunch for the following month at my school. They have two choices of lunches. Red or Blue. By their name the input of R or B is placed under the date. I need to count the number of R's and B's so I can know how much of each lunches I have to buy for? Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this be done?? | Excel Discussion (Misc queries) | |||
Semi Annual Counter | Excel Worksheet Functions | |||
insert picture | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |