You can use a Pivot Table to summarize the data. There are instructions
in Excel's Help, and Jon Peltier has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm


SchoolGirlNSTL wrote:
I have a worksheet with ballances, agency names and PI names. How can i set
up a subtotal that can display the ballance for the each agency AND the
balance for each PI within the agency? It seems i can only do 1.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html