Good Afternoon,
I am looking for some help, I am wanting to subtract values if a checkbox is selected to give me a total remaining if that makes sense, for my direct debits
I have attached an image of an example of the spreadsheet
any help would greatly be appreciated
thanks
Hi Ihagan10,
The SUMIF function is your friend.
Formula in D10 =SUMIF(E5:E8,"FALSE",D5:D8)
Or you could use a small table with a Header Row and a Footer Row, to allow the formula to refer to all Body Cells but exclude the Header and Footer Rows
Formula in Footer Cell D7 =SUMIF(E,"FALSE",D)
That will allow you insert or delete rows and the formula will automatically adjust.
Regards,
Ian.
Hi Ihagan10,
The SUMIF function is your friend.
Formula in D10 =SUMIF(E5:E8,"FALSE",D5:D8)
Or you could use a small table with a Header Row and a Footer Row, to allow the formula to refer to all Body Cells but exclude the Header and Footer Rows
Formula in Footer Cell D7 =SUMIF(E,"FALSE",D)
That will allow you insert or delete rows and the formula will automatically adjust.
Regards,
Ian.
Subtracting Value when checkbox is ticked
