how to increas the value of a cell using specific text or a checkbox from another cell

Hello All,

I have been searching the forums and cant quite find an answer for my question. here is the situation:

Example: I currently have a value of 10 in A1. I want to add 10 to that given certain criteria. 1: I type specific text into a different cell, or 2: I check a checkbox

I have tried this:

Private Sub LIVESCAN_Click()
If LIVESCAN.Value = True Then
Range("A1").Value = "=sum(A1,B1)"
Else
Range("A1").Value = ""
End If
End Sub

but when I put this code in. It displays nothing in A1 unless I link A1 to the checkbox (named livescan) it just displays "true" when checked and "false" when unchecked.
I have also tried using SUMIF but I dont understand how to get that to work. If someone could please help with either a VB code or a formula that would be great. Thanks!

I tried that and it is still returning nothing nothing in cell A1 unless I link it to that cell and then it just returns a true or false.

RST Packets.xlsx

Ok Here is the attachment, Basically what I want to do is add checkboxes in the Livescan, Core docs, and SF86 columns. And for example if I were to check a checkbox in the livescan column on row 16 it would change the completion from 10% to 20%. Thats what im trying to do, and have no Idea how to do it. As I mentioned above, the checkbox code in vb only returned a true or false value on a test sheet.