Hi all, I am preparing an excel file and I have an issue with the SUM formula.

In the file, I added a checkbox that will give 0 if FALSE (not ticked) or 125 is TRUE (ticked).

For this I used the formula =SUMIF(K21,TRUE,M21) where:

K21 is the true/false cell linked to the checkbox

M21 is 125

What I want to achieve is: When the box is ticked, add 125 to the final amount (in cell J37) and sum all prices in cells J26:J35 (and when the checkbox is not ticked, then 125 should not appear in the total sum).

Both formulas:

=SUMIF(K21,TRUE,M21)

=SUM(J26:J35)

Work separately, but they do not work together in the same cell, as I would like to have just one final cell (J37) that includes the amounts J26:J35 & SUMIF(K21,TRUE,M21).

Could you please help me with this?

​Hi all, I am preparing an excel file and I have an issue with the SUM formula. In the file, I added a checkbox that will give 0 if FALSE (not ticked) or 125 is TRUE (ticked). For this I used the formula =SUMIF(K21,TRUE,M21) where:K21 is the true/false cell linked to the checkboxM21 is 125 What I want to achieve is: When the box is ticked, add 125 to the final amount (in cell J37) and sum all prices in cells J26:J35 (and when the checkbox is not ticked, then 125 should not appear in the total sum). Both formulas:=SUMIF(K21,TRUE,M21)=SUM(J26:J35)Work separately, but they do not work together in the same cell, as I would like to have just one final cell (J37) that includes the amounts J26:J35 & SUMIF(K21,TRUE,M21).  Could you please help me with this?  Read More

​