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