Thread: Subtoal excluding hidden columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Subtoal excluding hidden columns
=SUM(A1,C1,F1,H1)

adjust to suit


"Trevor" wrote:

Does anyone how I can sum many columns within a row but exclude hidden colums
from the calculation?
The subtotal(109,"range") works for rows but not columns

Thank you!

Reply With QuoteReply With Quote