I have a spreadsheet that is an evaluation form.
It contains check boxes that correspondds to a cell that represents a value.
Is there a way to total those.
I will attach file so maybe to make more sense.

Attached Files

Evaluation Forms2.xlsx (29.4 KB, 14 views)

.
This is one method of which there are probably others :

https://www.get-digital-help.com/200...h-check-boxes/

For example : I separated the CheckBoxes rows 39:43. Removed the checkbox title,
placed the checkboxes in Col O ... the scores 4 - 0 in Col P and the word POINTS in Col Q.

With that, you could use Col S or Col T for the word TRUE from the formula found at this resource : https://www.get-digital-help.com/200...h-check-boxes/

Changing the font color to WHITE would make the word invisible.

Like I said, just one way ......

HI

You need to change your checkboxes so that they have an associated cell.
I made the associated cell O39 etc. the , where the checkbox is located.
By formatting these cells as Format > Custom > Number . ;;; the cell contents are not visible, although they will show TRUE or FALSE depending upon whether the checkbox has been selected.

Similarly, your Merged cells P39:Q39 have been formatted as Number > Custom >General "points"
Then typing a number e.g 4 into a cell, displays as 4 points, but it is stored as just the number so can be used in a formula

I only converted your first section to show the method in the attached workbook, and you will need to make the other changes down the sheet.

The formula to calculate is the array entered formula
{=SUM(O39:O43*P39:P43)} which is in cell V44

Your formula will be in cell S143 and will be {=SUM(O39:O138*P39:P138)}

To create an array formula, use Control+Shift+Enter (CSE) when entering or amending a formula. Do not type the curly braces { } yourself. When you use CSE, Excel will insert them around your formula.

Hope this helps.

Attached Files

Evaluation Forms2 #RJG.xlsx (200.6 KB, 11 views)

Thanks for the help.
Works great.