Can I make rows of an excell spreadsheet 'selectable' (on/off)?

[Guest]

I have a spreadsheet of 20 rows (and 20 coulmns). The bottom row of each
column is a total. I would like the user to be able to select the rows (using
like checkboxes or something?) to include in the column total row. Is this
possible?

 

[topola]

A4:A6 = {0,1} - your switches

In subtotal row write:
=SUM($A$4:$A$6*C$4:C$6)
followed by CTRL+SHIFT+ENTER
and copy to other columns.

 

[Guest]

With lots of coding you could add checkboxes, etc. An alternative would be
to add a column to one side of the other of your current range and tell the
users to enter "Y" or "x" in each row they want selected and then add a new
formula too total each column that uses a SUMIF() formula to only add the
rows where the user has entered the indicator. If that column was A, and the
20 rows started in row 2, the new formula for totalling column B would be

=SUMIF($A$2:$A$21,"Y",B$2:B$21)

 

[topola]

Alternatively:
=SUMPRODUCT($A$4:$A$6,C$4:C$6) with simple Enter