Thread: How to ignore hidden columns in an "Average" formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How to ignore hidden columns in an "Average" formula?
Try this if you can use 101 in your Excel version

=SUBTOTAL(101,A1:C1)




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DotK" wrote in message ...
If an "average" formula includes multiple columns, and those columns change
each month by hiding old months (at end) and adding new months (at beginning)
what can be done, by macro or in formula) to ignore the hidden columns?
Reply With QuoteReply With Quote