View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DennisB
 
Posts: n/a
Default Can I sum an outlined Excel sheet and ignore collapsed rows?

How can I sum a column of data values in an outlined Excel worksheet while
ignoring collapsed rows? I'd like to sum only the values that can be seen
on the worksheet, not in the rows that I've collapsed.
Thanks