+ Reply to Thread
Results 1 to 4 of 4

Subtotal filtered data IF criteria met on another cell

  1. #1
    Registered User
    Join Date
    09-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    5

    Subtotal filtered data IF criteria met on another cell

    Hi there,

    I want to combine a subtotal and sumif formula. i.e In my example - sum all based on company name when filtered on something like location

    I think a OFFSET formula is the answer, but I have tried and cannot understand how to do it

    any help greatly appreciated!!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,576

    Re: Subtotal filtered data IF criteria met on another cell

    In Y26 enter formula below, drag down and accross

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-15-2020
    Location
    malaysia
    MS-Off Ver
    office2007
    Posts
    345

    Re: Subtotal filtered data IF criteria met on another cell

    Y26 cell formula, Drag down and accross

    HTML Code: 
    =SUMPRODUCT(SUBTOTAL(9,OFFSET(Y$1,ROW($1:$23),,))*($H$2:$H$24=$X26))

  4. #4
    Registered User
    Join Date
    09-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Subtotal filtered data IF criteria met on another cell

    Thank you both for your answers! I tired the first formula and it worked :-) thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Aggregate based on filtered data (subtotal?)
    By Median in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2018, 05:03 PM
  2. [SOLVED] Subtotal of filtered data with one criteria
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2017, 09:22 AM
  3. [SOLVED] How can I calculate the subtotal for filtered cells that meet certain criteria?
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2015, 09:23 PM
  4. [SOLVED] Forumulas for Filtered Data =SUBTOTAL(A1:A2) Etc
    By Ben1985 in forum Excel General
    Replies: 3
    Last Post: 09-03-2013, 10:39 AM
  5. [SOLVED] Using Subtotal on Filtered Data with an additional condition
    By rau in forum Excel General
    Replies: 15
    Last Post: 09-06-2012, 08:03 AM
  6. [SOLVED] is date can be filtered to a different cell?-subtotal or any other function?
    By Morphyus C via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2005, 11:05 AM
  7. [SOLVED] Subtotal function with Filtered Data
    By RonB in forum Excel General
    Replies: 3
    Last Post: 08-12-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1