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.

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

Hi

if you're using Data / Subtotals - ensure that you've sorted your data using
Data / Sort with Agency selected in the first drop down box and PI selected
in the second. Then choose data / subtotals - run the subtotals for Agency,
then choose data / subtotals again - change the first drop down to PI name
and then UNTICK replace current subtotals

Cheers
JulieD

"SchoolGirlNSTL" wrote in message
...
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.

How can you get it to show both the Agency name and the PI names? It only
shows the PI names (actually different for me as I am not the original
poster).

"JulieD" wrote:

Hi

if you're using Data / Subtotals - ensure that you've sorted your data using
Data / Sort with Agency selected in the first drop down box and PI selected
in the second. Then choose data / subtotals - run the subtotals for Agency,
then choose data / subtotals again - change the first drop down to PI name
and then UNTICK replace current subtotals

Cheers
JulieD

"SchoolGirlNSTL" wrote in message
...
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.