I have an excel sheet that needs 3 columns where only a check box appears and is activated by someone clicking the box or pushing any button when the cell is selected.

Once this is done I need the cell to represent a 1 in a formula on another sheet that calculates the sum of all in that column.

I am currently imputing a 1 so the formula < =SUMIF(Data!A:A,A2,Data!C:C) > will work.

Does anyone have an idea?

Thank you!