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

Add Values if Checkbox is checked

Hello there,

I would like to add up values of certain cells if their corresponding check box is checked.
Here is the arrangement of the columns and values.

Column A-C: Not needed for the calculation
Column D: Price in €, D2-D5 have the following: 33.06, 32.12, 90.68 and 17.60
Column E: Checkbox

Now, I have a row for the total of these values. How would the formula be?
e.g. Checkboxes E2, E3 and E4 are checked, E5 is not. The total would be €155.86.

Thank you for your help.

Aluminium iMac 2.66 GHz 20", Mac OS X (10.6.4)

Posted on Sep 11, 2010 7:31 AM

Question marked as Best reply

Posted on Sep 11, 2010 7:54 AM

I tried it with SUMIF and it worked.

here is the solution: =SUMIF(Use;TRUE;Kosten)

Use = Column E
Kosten = Column D
1 reply

Add Values if Checkbox is checked

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