Share via

Excel subtotal function

Anonymous
2023-04-11T13:20:52+00:00

I don't use this very often, but is there a way to use the Sum 109 rather than the 9 which the dialog box defaults to? so instead of SUBTOTAL(9,H4:H7); have SUBTOTAL(109,H4:H7),

it's not very practical changing manually; I tried to use the SUBTOTAL directly say for each change in column M I want a subtotal of units, how do I tell it where to make the change? ,

Richard.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2023-04-11T13:34:45+00:00

    You can't change what the dialog does, but you can simply use a find/replace afterwards to replace subtotal(9 with Subtotal(109 in the relevant column(s).

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-11T14:01:36+00:00

    Ahh,
    I did think of F / R but did just for the 9 to 109,, which is not ideal if there's a 9 anywhere else,

    did not think of using the sub part . Thanks,

    Richard.

    0 comments