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.
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)