You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

mercuryflynn Author

Level 1

5 points

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

Top-ranking reply

Barry

Level 9

59,957 points

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

View in context

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

Similar questions