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

Adding up values in a column with conditions

I have one column with checkboxes and another with numbers. I am looking for a way to have Numbers add up the values in one column as long as the corresponding checkbox in another column is checked. Can anyone help me with this?

Mac mini, OS X Mountain Lion (10.8.2)

Posted on Nov 11, 2012 10:15 AM

Reply
Question marked as Best reply

Posted on Nov 11, 2012 10:25 AM

Stickman,


This may do the trick:

User uploaded file


B11=SUMIF(C, "=TRUE", B)

2 replies

Adding up values in a column with conditions

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