Getting sum of different variables

aNXNEqXmcpjLqofkRL2BbQ.xlsx (12.8 KB)
Hallo. I would like to get sum of different variables with Yes/No i.e Yes=23,No=0/ Yes=20,No=0 e.t.c. I have 23 variables with different scores as Yes/No. How do i go about. Check attached excel with variables LSM1-23. Thanks.

Welcome back to the community, @Ruvuga! You could add as discussed in our previous post:

Note, if there are any blank entries, you could add using the coalesce as discussed in our previous post:

1 Like

Thanks alot it worked very well using coalesce.

1 Like