Evaluation Score Card

[tjrossaz]

Hello,

I am using check boxes to create a score card for a training activity. I have assigned each check box a value using the below formula, however I need to add to it in order to total all values for check boxes clicked on in a single row. Any help would be much appreciated. Thanks!

My formula:
=IF(K2=TRUE,1,IF(L2=TRUE,2,IF(M2=TRUE,3,IF(N2=TRUE,4,IF(O2=TRUE,5,IF(P2=TRUE,6,0))))))

 

[Eric W]

If you want a formula to sum the values of the checked boxes, try:

=SUMPRODUCT(--(K2:P2),{1,2,3,4,5,6})

 

[tjrossaz]

If you want a formula to sum the values of the checked boxes, try:

=SUMPRODUCT(--(K2:P2),{1,2,3,4,5,6})

Thanks Eric! That was a lot easier...

 

[Eric W]

Glad to help!