hi ... this is babarmalik..

.....
is there any way to eleminate the hidden cells from sumtotal... i.e while using autofilters, sumtotal should be changed with any change in sorting through autofilter....

i am really cofused in solving this problem ...
plesae help me