Data set with rows hiddened.

[gary19692011]

Hi can you please help with this simple question?
if I have data in a column that I need to simple add up at the bottom of the data but I need to hide either one or more random rows within the data set but I don't want that data included in the calculation, what is the best formula for this?

Many thanks

Gary

 

[martindwilson]

=subtotal(109,b1:b20)

 

[gary19692011]

Thanks Martini will give that a go.