Optional Rows in calculation

[teezecrost]

Hi there. This seems really simple, but honestly not sure how to accomplish.
I'm making a simple trip planner in excel, and I have a total row to total expenses. I'd like to be able make certain trip expenses optional so we can quickly see how skipping/attending certain things affects our total cost.
Is there any way to do this without deleting the optional rows?
Thanks!

 

[AlanY]

you can hide the rows not needed and use subtotal(109,...) with option to ignore hidden cells

 

[Tom Baron]

you can hide the rows not needed and use subtotal(109,...) with option to ignore hidden cells

Love this tip!

 

[Tom Baron]

Although above is really good. Alternatively, you could add another column, then use sumproduct(([NEWCOLUMN]=1)*[VALUECOLUMN]). Then simply put a 1 in any row you want to total

 

[Tom Baron]

Where column V contains the 1s and column T contains the costs:
=SUMPRODUCT(($V$17:$V$148=1)*$T$17:$T$148)

 

[teezecrost]

Great options. Thanks, everyone!