Dave Peterson wrote

Did you use Data|Subtotal to add the =subtotals()?

If yes, then I'd remove those subtotals, add the new person, sort the
data and reapply data|subtotals.

If you do this lots of times, you may want to record a macro when you
do it.

No, I didn't. I just put =Subtotal() formulae in desired cells.
Thanks for the input.

--
David