Reduce cell value based on checkbox

Question

Reduce cell value based on checkbox

Anonymous

Hello everyone,

I would like to build a formula where the total amount will add or subtract based on whether a checkbox or command is entered in a cell next to the amount, for example; if I have 3 columns with €100, then the goal is for the column with the grand total of €300 to subtract by €100 for every box checked.

Apologies if this question has already been asked and thank you in advance for the assistance

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

1 additional answer

Answer 1

Hi,

Please check whether the following solution is helpful:

Formula in cell D1 is: =SUM(A1:C1)-SUMIF(A3:C3,TRUE,A1:C1)

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Answer 2

Anonymous

This was exactly what I needed.

I appreciate the quick response!

Share via

Reduce cell value based on checkbox

1 additional answer