Comments on: Excel SUBTOTAL function with formula examples

The tutorial explains the specificities of Excel SUBTOTAL function and shows how to use Subtotal formulas to summarize data in visible cells. Continue reading →

Table of contents

Comments page 2. Total comments: 33

  1. hi could you pls help me out how to enable the Function_num drop down options in Subtotal because I'm using macbook and i am unable view the numeric option .

  2. Is there any way to use formula containing cell as my excel table header rows?

  3. Yes, it has fulfilled my need. Thank you very much.
    I want to use my data sheet rows data containing formula as standard table headers. How can I do this?

  4. I want to count column A for Duplicate, triplicate, quadruplicate, sextuplicate values in column B. Also i want to multiply these Duplicate, triplicate, quadruplicate, sextuplicate terms with their values which are repeated in column A.

    1. Hi Zeshan,

      It will make things a lot easier if we could see your dataset. If you can send us your sample worksheet (support@ablebits.com) with the source data and expected results, we will try to help.

      1. I am grateful for your reply. My query is emailed.

        1. Zeshan,

          I've emailed you the formula. Hopefully it delivers the expected result.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)