Multiple Countif ?

B

BIYB

I want to award point for certain daily activities

Say 1 point for having done a great job
say 0 points for having done a regular job
say -1 (minus 1) point for a bad job

IN a table I would use "G" for great, "R: for regular, and "B" for bad,
these would be inserted on a daily basis. Basically I want a running tally at
the end of the collum to see where each team member is at in terms of points.

Thank You
 
D

Dave O

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

B. R.Ramachandran

Hi,
Since the number of rows is expanding as you add new performance data on a
daily basis, you would be better off to have the running tally for each
member on the top of the column (rather than the bottom) for each member (I
guess members are listed column-wise).
If, for example A1, B1,C1, ...... contain Member 1, Member 2, Member 3,
......., then the running tallies may be in A2, B2, C2, ......., and the daily
performance data (such as G, R, or B) may start at row 3 (i.e., A3, B3, C3,
......)

The formula in A2 could be:

=SUMPRODUCT((A3:A1000="G")-(A3:A1000="B"))


Fill-in this formula across Row 3 to columns B, C, ......(for other members)
This formula would work with the grading criterion you have indicated (G=1,
R=0, and B=-1). If you decide to use a different criterion, the formula
should be modified accordingly. The following is a more general formula:

=SUMPRODUCT((A3:A1000="G")*1+(A3:A1000="R")*0+(A3:A1000="B")*(-1))

Here, the 1, 0, -1 after the *-sign in the formula can be changed to any
other grading criterion you may decide to use later.

Regards.
B.R. Ramachandran
 
B

BIYB

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

Bob Phillips

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