Google sheets checkmark conditional Formating-CodePudding

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

CodePudding user response：

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)

CodePudding user response：

Try below formula-

=QUERY(A2:C9,"select sum(A) where B=True or C=True label sum(A) ''")