Hi
only possible with VBA.
SUBTOTAL would work if you would hide rows with a filter

--
Regards
Frank Kabel
Frankfurt, Germany

"Todd" schrieb im Newsbeitrag
...
I have a worksheet with many hidden columns. The columns I hide keep
changing. Is there a way to have column totals adjust to sum only
the
columns showing?

TIA

Todd