Need to insert a counter for supplies ordering.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 16 Aug 2006 20:39 GMT

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 to this Message

David Billigmeier - 16 Aug 2006 20:44 GMT

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

Signature

Regards,
Dave

> 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 to this Message