Totaling Subtotals


C

Craig

Hello. I'm using Excel 2003.

I'd like to total the subtotals that Excel calc'd for me using the subtotals
function. I realize that Excel places a grand total at the bottom of the
data range. However, I have one field that is using a "Max" calculation ie,
"=subtotal(4, A1:A5000)"

I want to sum all of these "Max" calculations. However, when you use the
"=subtotal(9, A1:A5000)" formula, it doesn't sum all of the subtotal max
calcs - it sums the data only. So, this WON'T WORK.

Any suggestions?

Thanks.
 
Ad

Advertisements

J

Jim Cone

Craig,

=Sum(A1:A5000) - Subtotal(9, A1:A5000)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Craig" <[email protected]>
wrote in message
Hello. I'm using Excel 2003.
I'd like to total the subtotals that Excel calc'd for me using the subtotals
function. I realize that Excel places a grand total at the bottom of the
data range. However, I have one field that is using a "Max" calculation ie,
"=subtotal(4, A1:A5000)"
I want to sum all of these "Max" calculations. However, when you use the
"=subtotal(9, A1:A5000)" formula, it doesn't sum all of the subtotal max
calcs - it sums the data only. So, this WON'T WORK.
Any suggestions?
Thanks.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top