Link to home
Start Free TrialLog in
Avatar of Michael V Bernot
Michael V BernotFlag for United States of America

asked on

Sum Across Columns Ignoring Hidden Columns

Is there a function in Excel that would allow me to sum across columns ignoring hidden columns?  I know the SUBTOTAL function and AGGREGATE function will ignore hidden rows, but is there any function that will allow me to do the same (ignoring hidden) when crossfooting a worksheet?
ASKER CERTIFIED SOLUTION
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael V Bernot

ASKER

Thank you for the information.  

Michael