On Tue, 6 Dec 2005 05:20:03 -0800, "pj" wrote:

In my worksheet I have a SUM equation which sums every subtotal. I currently
have 30 subtotals.
When I try to add one more I get a the following message:

You have entered too many arguements for this function. It then directs me
to the = sign on the formula bar.

How do I update this without combining some of the earlier subtotals

Thanks - PJ


If you are generating (or could generate) your SUBTOTALS using the SUBTOTAL
worksheet function, then if there are other subtotals within ref1, ref2,… (or
nested subtotals), these nested subtotals are ignored to avoid double counting.

I believe that the included SUBTOTALS are identified by the fact that they are
generated by using the SUBTOTAL function (rather than by using the SUM
function).

The SUBTOTAL(9,cell_ref) function does not include hidden rows, and does not
include nested subtotals, but otherwise should function similarly to the SUM
function.


--ron