Subtotal / turning rows on/off

[jsmith70]

i have a list of names / salaries that extend multiple years (columns). i would like to add a function that i can turn on/off cells representing salary to see the total at the bottom with/without certain salaries.

i want to be able to toggle name 2 on and off to see how the totals change in 2019 / 2020

for example

name / 2019 salary / 2020 salary

name 1 / 150000 / 175000
name 2 / 95000 / 125000
name 3 / 125000 / 150000

... / 2019 total / 2020 total

 

[shg]

You can use =SUBTOTAL(109, range) and then hide rows to omit them.

 

[jsmith70]

thank you - is there a simpler way instead of right clicking and hiding the road, then unhiding, then hiding etc.. ? like a toggle

 

[shg]

The are many ways it could be done. You could insert a column and put an X next to the names you want to include (or exclude).