Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Spreadsheet Subtotal Formula - Possible Bug

Subtotals that include other subtotals are supposed to exclude the value of subordinate subtotals from the final total.

For example:

In Excel it does not add subordinate subtotals to the final subtotal:

In IgniteUI JavaScript Spreadsheet the subtotals are incorrectly added up:

This greatly affects the usability of subtotals. Is there a way around this?

  • 21655
    Verified Answer
    Offline posted

    Hello Brian,

    I have investigated your issue, and I have asked our engineering staff to examine why SUBTOTAL function does not ignore other SUBTOTAL values in range further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 258183. This will be assigned to a developer in a future sprint to review my investigation and confirm my findings or to offer a fix, or other resolution.

    Please let me know if you need more information.