I need help with Google spreadsheet checkmark conditional formatting. Please see the image for a better understanding. When I click on the C2 cells checkmark then automatically A2 cells $10 will be selected and added to the E5 cells. When I click on the B6 checkmark then automatically A6 cells $40 will be selected and added to the E5 cells. Summary of the concept: When I checkmark any cells (from B2 to B9 & C2 to C9) the same row (From A column) number will be added automatically to the specific cells(to E5 cells). How do I do it?
Sheet Link (I have given edit permission, you can edit it) – Go to sheet link
>Solution :
try:
=INDEX(SUM(IF(B2:C9=TRUE, A2:A9, 0)))
or:
=INDEX(SUM(IF((B2:B9=TRUE)+(C2:C9=TRUE), A2:A9, 0)))
or try:
=SUMPRODUCT((B2:B9=TRUE)*(C2:C9=TRUE)*A2:A9)
=SUMPRODUCT(((B2:B9=TRUE)+(C2:C9=TRUE))*A2:A9)