Results 1 to 29 of 29

Using the same Data set from a subtotal formula to put into a sumproduct formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    California
    MS-Off Ver
    Office 2010
    Posts
    13

    Using the same Data set from a subtotal formula to put into a sumproduct formula

    I have a spreadsheet with Subtotals already in it. I've come up with this formula:
    =SUMPRODUCT(SUBTOTAL(9,OFFSET($V$3,ROW(V4:V4)-ROW($V$3),0))*(R4:R4=$B$1))

    Which I inserted in the cell next to the subtotal formula:
    =SUBTOTAL(9,V4:V4)

    How do I repeat the SUMPRODUCT formula so it has the same data set range that the next SUBTOTAL uses?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF or SUMPRODUCT or any formula for this data set?
    By millz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2016, 03:41 AM
  2. [SOLVED] Sumproduct or any other formula for filtered data
    By toci in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 08-24-2016, 03:55 PM
  3. [SOLVED] sumproduct formula for horizontal data
    By Jules Pop in forum Excel General
    Replies: 7
    Last Post: 08-08-2014, 05:25 AM
  4. Best Formula... SUMPRODUCT with SUBTOTAL?
    By excellenthelp in forum Excel General
    Replies: 1
    Last Post: 12-19-2013, 04:14 PM
  5. Need Excel formula in Macro using Subtotal formula with If function
    By mbnewton1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2013, 03:00 PM
  6. Replies: 2
    Last Post: 06-12-2012, 10:18 PM
  7. Custum subtotal formula for autofiltered data
    By 1eyedjack in forum Excel General
    Replies: 2
    Last Post: 02-08-2012, 11:14 AM

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