Display the sum of shown/unhidden cells only

[jayson529]

i would like a cell to display the sum of shown/unhidden cells.

if a1 = 2, a2=4, a3= 5 a4=3 and the autosum displayed at a5=14

if i will hide a2, the autosum displayed at a5 must be 10 only and not 14...
meaning, it will only add up all values from a1 to a4 that are shown/unhidden... hidden rows will not be included in the sum...

can this be done and how would i do it.

please help, i need this badly...

 

[dva7pbi]

a5=subtotal(109, a1:a4)

 

[jayson529]

Wow! That's FAST!!! Thank you so much!!! It works!!!

Maraming Salamat!