クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

SUBTOTAL does not allow Function_num that "ignores hidden rows"

計画済み
デモをリクエスト

Hi,

I've been trying without luck to use the SUBTOTAL formula to exclude hidden rows as a useful way to check if my total in the tables of the Financial Statements matches with the total in the Master File, although I got a error message saying that the Function_num that ignores hidden rows are not supported.

Is there another way to tackle this?

Thanks a lot in advance.

Pedro

1

コメント

3件のコメント

日付 投票
  • Courtnie Carver
    • 編集済み

    Hello Pedro, 

    We have had questions about this in the past which you can view here.

    The good news is that this enhancement has already been added to the future roadmap. No specific timeline to share as of yet, but it's a step in the right direction. We will get you added to the list of supporters for this feature and you will be updated with any progress/updates. 

    Thank you!

    1
  • Jennifer Flores

    Hi, since the SUBTOTAL formula is not currently an option,  is there another way to get the same end-result? 

    0
  • Pedro Andrade

    Hi Courtnie,

    Thank you for your prompt reply.

    I guess I've just come around a way to double check if there are hidden rows in the meantime we wait for the Subtotal enhancement.

    Yes, please add me to the list of supporters for this feature! ;)

    Regards,

    0

サインインしてコメントを残してください。