Thread
:
How do I get excel to sum a range without including hidden cells?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How do I get excel to sum a range without including hidden cells?
look in the help index for SUBTOTAL
--
Don Guillett
SalesAid Software
"Jet" wrote in message
...
I need to sum a total dollar amount from a column in a spreadsheet. But I
need to hide certain rows after they are no longer needed. I don't want to
simply delete these as I may need to reference them later. The problem is
the
running total I have always includes all the cells, hidden or not. I would
like the running total or SUM to not include the hidden rows. How can this
be
done?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett