Hi there,

This might seem like an obvious question so im sure someone out there will get this one easy.

I have a checkbox where the values are reflected as True/False in a seperate column, what i simply want to do is take the value from one cell, and add 10% of the value each time a value becomes True.

For example in this value column after the check box has been filled out it might look like this:

False
True
True
True
False
False
False

The cell then needs to take the figure, lets say, 100, add 10%, then add 10% to 110, then again and so on for however many "True" statements are in the column.

I have tried with no success with various SUM/SUMIF/COUNT/COUNTIF/IF etc cant seem to get it to work, im not sure the cell refreshes correctly after the checkbox is filled out and its not registering the new "True" value as by default its all set to "False".

Any help on this would be greatly appreciate, youve all been very helpful in the past and i hope you can help me out again.

Kind Regards,
Lewis