CODEWITHSUNDEEP
if-statementgoogle-sheetscheckboxsumgoogle-sheets-formula
user17512898
user17512898

Reputation:

Google sheets checkmark conditional Formating

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

enter image description here

Upvotes: 1

Views: 633

Answers (2)

player0
player0

Reputation: 1

try:

=INDEX(SUM(IF(B2:C9=TRUE, A2:A9, 0)))

enter image description here

or:

=INDEX(SUM(IF((B2:B9=TRUE)+(C2:C9=TRUE), A2:A9, 0)))

enter image description here

or try:

=SUMPRODUCT((B2:B9=TRUE)*(C2:C9=TRUE)*A2:A9)

=SUMPRODUCT(((B2:B9=TRUE)+(C2:C9=TRUE))*A2:A9)

Upvotes: 0

Harun24hr
Harun24hr

Reputation: 36870

Try below formula-

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

enter image description here

Upvotes: 0

Related Questions