I'm guessing that you used Data|Filter and Data|Subtotals at the same time.

If you filter to hide the details, then =subtotal() will ignore the hidden rows.

Either drop the filter (and use the outlining symbols to the left) or drop the
data|subtotals.

Maybe you can use row 1 to show the subtotals:

=subtotal(x,A3:A###)

kind of formulas.

Lorie wrote:

example: I have a sum for the amount of time people worked with clients. it
shows up when all the clients are showing. but if I only show one client,
then no sums show up for that client, only the time worked on any given day,
is there a way to make the sum show up that totals all the time for the
client worked to date?
--
thank you, LM

--

Dave Peterson