Need to insert a counter for supplies ordering.

P

Phil

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.
 
D

David Billigmeier

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")
 
Top