I am creating a spreadsheet that several different people (who all want to
see different aspects of the spreadsheet) need to use. I want to be be able
to use the autofilter so that the various people can easily and quickly zero
in on ONLY the information that they want to see, but then the SUBTOTAL
functions get messed up. I do not want to use the SUM functions because there
are so many subtotal lines it would be difficult to specify what needs be
included/excluded in a SUM function.