Assuming the gradings are in B6:J8,

=COUNTIF(B6:J6,"G")-COUNTIF(B6:J6,"B")
etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BIYB" wrote in message
...
Column A is the persons name, across the top (row 1) is the date.

Date July5 July6 July7 July8 etc
Points
total
Name

Bob
Mike
Sam
ETC

Basically each person get a rating for each day "G", "R" and "B" (which
has
a predetermids score associated to it, and the last column tallies the
total
points.

"Dave O" wrote:

How is your data laid out in the spreadsheet? The layout will
determine the way to count the points. For instance: column A might
hold the person's name, column B the date, column C the activity, and
column D the great/regular/bad rating.