MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Subtotal - More than one function?


Posted by Elizabeth on February 08, 2001 9:45 AM

Is there a way to do more than one subtotal function at once? For example, I have a large spreadsheet that I am subtotaling. Some of the columns I would like to sum, others I would like an average or count. Is there a way to do this all at once? The only shortcut I found is to do one function (i.e. sum) and then do an edit replace in the columns I want to average. Please help!


Posted by Wayneo on February 08, 2001 1:54 PM

Elizabeth,

Couple of questions....how often does your data change (meaning do you update daily, mothly...)? Will the function you want to perform always be the same function performed in that column?

Wayneo

Posted by Elizabeth on February 09, 2001 6:36 AM

Thanks for your responses. It changes all the time. We run data off our system as needed and drop it down into Excel so we can work with it. The worksheets are not always the same size or have the same number of coumns, etc.

Posted by Wayneo on February 09, 2001 11:54 AM

Elizabeth,

Have you every used pivot tables? This might help you work with your data. Let me know and I can walk you through how to use pivot tables.

Wayneo