Share via

Excel Aggregate and subtotal

Anonymous
2023-11-14T15:44:54+00:00

Has anyone come up with a way to combine aggregate and subtotal,

I would like the ignore errors with Aggregate but also have any filtering respected

Richard.

Microsoft 365 and Office | Excel | For business | 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

Rory Archibald 18,965 Reputation points Volunteer Moderator
2023-11-14T16:27:55+00:00

Hidden rows and errors is 7

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-14T17:01:16+00:00

    Thank you, I'll blame my specs for not being stronger.

    RD

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-11-14T16:20:13+00:00

    Yes, but I need it to also ignore errors and it only seems to take one condition,

    I did try {5,6}, but this results in a spill for each answer one ignores errors, the other can be filtered.

    Richard.

    Was this answer helpful?

    0 comments
  3. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2023-11-14T16:01:51+00:00

    AGGREGATE already respects filtering if you use any of the ignore hidden rows options.

    Was this answer helpful?

    0 comments