Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Need a formula to have check marks control adding up cells in different column

Trying to use numbers for a quick & dirty budget. I'd like a column of check boxes to control whether or not a different column's cells are totaled up.


For example, C column is full of prices. D column is all check marks. I'd like the footer cell of D column to total up ONLY the cells in C column that have a checked box next to them in D column.


I'm not the best with formulas yet, and this one is stumping me. Thanks!

MacBook Pro (2020 and later)

Posted on Apr 29, 2021 12:29 PM

Reply
Question marked as Top-ranking reply

Posted on Apr 29, 2021 4:03 PM

SUMIF is your friend here.


Convert the bottom row of the table (where the SUMIF formula is to go) to a Footer Row.


Enter this formula in the footer row cell of column D:


SUMIF(D,TRUE,C)

And with all boxes checked:


Regards,

Barry

Similar questions

1 reply
Sort By: 
Question marked as Top-ranking reply

Apr 29, 2021 4:03 PM in response to mercuryflynn

SUMIF is your friend here.


Convert the bottom row of the table (where the SUMIF formula is to go) to a Footer Row.


Enter this formula in the footer row cell of column D:


SUMIF(D,TRUE,C)

And with all boxes checked:


Regards,

Barry

Reply

Need a formula to have check marks control adding up cells in different column

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.