Create a list will all the chores like for instance in G

don't know if you are looking to count the different points or if you are
using the names of the chores but assume the list of all chores used are in
G2:G8 (adapt to fit)
I am also assuming that your chores can be spread out in A2:F162,
In the first adjacent cell to the first value in your newly created list
(that would be H2) put this formula


=COUNTIF($A$2:$F$162,G2)

copy down as long as needed by dragging the lower right corner of the cell
with the formula

if the chores are in A2:A162 only change the formula to


=COUNTIF($A$2:$A$162,G2)


--
Regards,

Peo Sjoblom





"TN Judge" wrote in message
...
I have 129 kids at my church and they have been charged with doing certain
things to earn points. I am making a spreadsheet to record their
accomplishments, like, if they study their lesson they get 10 points, if
they
memorize a verse, they get 15 points, if they participate in a fund raiser
they get 50 points, and so on. I have a chart that shows their points and
can figure out their total points earned. However, I want to know how
many
times a certain chore was completed. I am trying to find out how many
times
each point value appears in the whole chart. That way I'll know which
things
the kids are doing the most, which may show me I need to add or delete an
assignment. Right now I have A2 through A161 and A - F columns. Anyone
have
a light bulb go on??? Thanks.