Skip to main content
March 17, 2023
Question

Subtotals Dialog Box

  • March 17, 2023
  • 1 reply
  • 0 views

Please see attached screenshots.

 

I am trying to subtotal Column Q at every change in column E. I have sorted the sheet A to Z. I go to Data Tab and then under "outline" group I click on "subtotal". The subtotal dialog box opens as shown. The first drop down is correct "at each change in SOURCE NAME" I then select Sum...no problem. The problem is the Add Subtotal to: I only have one column to select from and I need to select column Q "Open Balance". All the instructions I see indicate all columns should be an option in the "Add Subtotal to:" box. How do I choose the column I want to subtotal? 

 

Additionally the drop down arrow "At each change in:" will only display the column I have selected a cell in. So I can't select anything there either. 

1 reply

Candice C
March 17, 2023

Good afternoon, @Susan1216

 

It's great to see you back in the Community. Let's work together to get this figured out. 

 

To clarify, where are you performing these actions to get to this point/problem? 

 

Before moving forward, we'll need that extra piece of information and then we'll be able to determine the best solution for this issue. I'll be right around the corner when you're ready!