Results 1 to 3 of 3

Thread: Subtotal with Filtering

  1. #1
    Junior Member
    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    Question [Solved] Subtotal with Filtering

    In this Sheet, I need to get subtotal according to filter.


    Thanks a lot in advance
    Attached Files Attached Files
    Last edited by Sakalansalex; 10-25-2017 at 03:27 PM. Reason: Solved

  2. #2
    Junior Member
    Join Date
    May 2013
    Posts
    26
    Rep Power
    0
    Welcome to the forum!

    =SUBTOTAL(109,F2:F12)

  3. #3
    Junior Member
    Join Date
    May 2013
    Posts
    2
    Rep Power
    0
    Quote Originally Posted by Kenneth Hobson View Post
    Welcome to the forum!

    =SUBTOTAL(109,F2:F12)
    Thank you Mr. Kenneth for your help, but unfortunately the formula didn't fit my demand

    Here is a solution from a friend;

    The formula is:

    =SUMPRODUCT(SUBTOTAL(109;OFFSET(F3;ROW($F$3:$F$12)-ROW(F3);;1));--($D$3:$D$12="M"))

    Thank you all for your help

Similar Threads

  1. Replies: 6
    Last Post: 05-21-2014, 08:58 PM
  2. Drop-down list (with filtering)
    By mahmoud-lee in forum Excel Help
    Replies: 2
    Last Post: 02-22-2014, 12:44 AM
  3. Copy pivottables subtotal to new sheet.
    By jwitte in forum Excel Help
    Replies: 6
    Last Post: 09-13-2013, 05:57 PM
  4. Did You Know :: Excluding Hidden Cells from SUM (and other) Formulas – SUBTOTAL
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-23-2013, 07:51 PM
  5. Replies: 5
    Last Post: 12-05-2012, 03:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •