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...
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...