• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Nested Subtotal Issue

test

New Member
Hi,

I have done this so many times in the past it is second nature. However, for some reason I am now having an issue. Is it me? Am I forgetting a step?

I have 135 employees assigned to 4 groups, and the 4 groups are further subdivided down into 15 different organizations.

I sorted the 135 records by group and then by organization. I want to subtotal by organization, and then by group. When I subtotal by organization or by group individually I get 135 as the grand total. However, when I sort by organization 1st, getting 135 for the organization total, and then by group, I get 149 as the grand total for group.

It should have 135 as the total for both organization and group.

Thanks for the help.
 

Attachments

  • Book1.xlsx
    13.7 KB · Views: 5
Hi ,

Your formula in column C should be :

=SUBTOTAL(2,C2:C153)

Otherwise you are counting the text items also.

See the attached file.

Narayan
 

Attachments

  • Book1.xlsx
    17.7 KB · Views: 2
Last edited:
HI, Thanks for the reply. Yep, that is the issue.

However, why is Excel not doing this automatically as it has in the past?

I use the subtotal button on the Data menu and in the past I just keep using that button to nest subtotals, and never have to manually make a change to the automatically generated formulas.
 
Back
Top