If you have an indicator in each row that identifies the group, you can sort by
that indicator and then use data|subtotals to get the subtotals.

Depending on what you're doing, you may find using a pivottable
(data|pivottable) (still requiring that indicator field) may be easier and
quicker.

Tiffany wrote:

Is there a quick way to subtotal by groupings, ie everty 100 rows, insert a
subtotal?
--
TASR

--

Dave Peterson