automatic tally for a total score

G

Guest

I am an English teacher and I have created a "grading rubric" for an essay
assignment in my class. This rubric has 20 criteria in rows on which the
students' work is to be graded, such as "Grammar," "Spelling," etc.

There are five columns next to each criteria, each designating the score
that the student should receive for each criteria - Column #1 designates a
full five point score for that criteria, Column #2 designates a four point
score in that criteria, etc.

What I want to do is place a radio button or a check box in each table cell
that, when selected, automatically adds that amount to the total score. The
total scores should be displayed in a cell at the bottom of the worksheet.

In other words, if a student's work deserves a "4" for Grammar, I want to be
able to select that radio button or check box that resides in the "4" column
next to the "Grammar" row, and have that amount automatically be added to the
"Total Score" cell.

Your assistance in helping me with this would be greatly appreciated.
 
J

Jason Morin

I would say keep it simple for now and just use "x" to
mark a cell. Assuming categories are in A1:A20 and an "x"
placed in one of the adjacent 5 columns, use:

=SUMPRODUCT((B1:F20="x")*{5,4,3,2,1})

HTH
Jason
Atlanta, GA
 
G

Guest

That works nice and is really simple. Thank you.

Jason Morin said:
I would say keep it simple for now and just use "x" to
mark a cell. Assuming categories are in A1:A20 and an "x"
placed in one of the adjacent 5 columns, use:

=SUMPRODUCT((B1:F20="x")*{5,4,3,2,1})

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top