Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Subtotal Features




  • Official comment
    Isabel Messore

    Great news! A recent release has added some upgrades to our SUBTOTAL formula, notably that it now supports the hidden ell operators 101 thru 111. By default, this functionality is enabled though there are some caveats (listed below). New files or embedded tables will automatically upgrade to this formula version and any existing files (including copies) will be automatically upgraded to this formula version. Should you run into any scenarios where your formula is impacted by this change and not yet upgraded, you can reach out to your CSM or our Support team and they can assist in getting those migrated.

  • Brandon Ehrecke

    Hi James!

    Thanks for providing this feedback! I'm not aware of this currently being worked on so I have gone ahead and submitted this as an idea to our product team to review. You will be updated with any progress. Anyone else passing by is encouraged to up vote or comment on this suggestion. Let us know if you have any additional questions. Thanks! 

  • Caroline Wilson

    Hi both 

    I raised this with Workiva Support back in May 21.  A very useful function in Excel to help detect data in hidden rows.


Please sign in to leave a comment.