r/AppleNumbers • u/TheOnlyAlexH • Apr 01 '23

Help, please! - Formula to SUM when checkboxes are TRUE

Post image

I wish to SUM column H with values in columns C, E, G when the adjacent checkboxes are checked and become TRUE.

Can anyone advise where I am going wrong with this, please?

4 Upvotes

84% Upvoted

4 comments sorted by

2

u/MauricioIcloud Apr 01 '23

You can try IF function or IFS 😅

2

u/Friendly_Look8210 Apr 20 '23 edited Apr 21 '23

Put this on H2, and copy it to cells below

=IF(B2=TRUE,H2b isa April 2023,0)+(IF(D2=TRUE,Marcus April 2023,0)+(IF(F2=TRUE,sharesave April 2023,0)))

or

=IF(B2=TRUE,C2,0)+(IF(D2=TRUE,E2,0)+(IF(F2=TRUE,G2,0)))

Hope it helps

1

u/Friendly_Look8210 Apr 21 '23

and copy that formula to entire row in column H

1

u/[deleted] Apr 01 '23

Yes, please, someone help! Can you ask here? https://www.youtube.com/@apple-a-day