Results 1 to 11 of 11

sumproduct subtotal offset with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    Little Rock, KS
    MS-Off Ver
    2007
    Posts
    9

    sumproduct subtotal offset with multiple criteria

    I'm trying to modify my formula to add if a current cell in Column G isn't equal to the preceding cell in Column G as well.... In other words adding in multiple criteria statement. Anybody know how to add this to my formula?
    Right now as you can tell from my formula, column L is my summing column. My formula works great, but I wanted to make it a little more robust.

    Thanks,

    Renee

    '=SUMPRODUCT(SUBTOTAL(109,OFFSET($L10,ROW($L10:$L108)-ROW(L10),,1)),--($R10:$R108=0))
    Last edited by reneevic; 05-31-2016 at 05:56 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to use VBA to write " SUMPRODUCT(SUBTOTAL(3,OFFSET"....
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2016, 06:05 AM
  2. Replies: 5
    Last Post: 02-06-2015, 08:44 PM
  3. [SOLVED] SUMPRODUCT*OFFSET with Multiple Ifs??
    By pncarlson in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-06-2014, 08:37 PM
  4. [SOLVED] Sumproduct, Subtotal with multiple condition
    By ravi.jalani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2013, 12:18 PM
  5. Extract data using offset & multiple vlookup (sumproduct)
    By Navin Agrawal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-30-2013, 08:34 AM
  6. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  7. subtotal - multiple criteria
    By mdma in forum Excel Formulas & Functions
    Replies: 102
    Last Post: 09-06-2005, 07:05 PM

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