outline & groups

G

G Gustavo

I have a worksheet with data that contains the following headers:

Year Dollars Vendor Invoice # and Vendor Name

I want to group each year information in to a Group and have a subtotal of
that year and be able to do it for all five years that I have, how do I do
this with Outline and Group functions.

Thanks

Gustavo
 
R

Ray A

One way;
Data>Sort>Year with header row
Data>Subtotals>At each change in Year>Sum> Dollars
HTH
 
Top