Results 1 to 29 of 29

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

Threaded View

g_data2017 Using the same Data set from... 05-18-2017, 07:28 PM
FlameRetired Re: Using the same Data set... 05-19-2017, 12:17 AM
g_data2017 Re: Using the same Data set... 05-19-2017, 10:44 AM
FlameRetired Re: Using the same Data set... 05-19-2017, 12:19 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 01:11 PM
FlameRetired Re: Using the same Data set... 05-19-2017, 01:26 PM
CK76 Re: Using the same Data set... 05-19-2017, 01:44 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 01:50 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 01:47 PM
CK76 Re: Using the same Data set... 05-19-2017, 02:04 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 02:08 PM
CK76 Re: Using the same Data set... 05-19-2017, 02:18 PM
FlameRetired Re: Using the same Data set... 05-19-2017, 02:38 PM
CK76 Re: Using the same Data set... 05-19-2017, 02:42 PM
CK76 Re: Using the same Data set... 05-19-2017, 02:46 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 02:47 PM
CK76 Re: Using the same Data set... 05-19-2017, 02:54 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 02:56 PM
FlameRetired Re: Using the same Data set... 05-19-2017, 04:00 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 04:09 PM
FlameRetired Re: Using the same Data set... 05-19-2017, 06:38 PM
g_data2017 Re: Using the same Data set... 05-19-2017, 07:06 PM
FlameRetired Re: Using the same Data set... 05-19-2017, 08:01 PM
g_data2017 Re: Using the same Data set... 05-23-2017, 03:08 PM
FlameRetired Re: Using the same Data set... 05-23-2017, 04:08 PM
g_data2017 Re: Using the same Data set... 05-23-2017, 05:31 PM
FlameRetired Re: Using the same Data set... 05-23-2017, 07:43 PM
g_data2017 Re: Using the same Data set... 05-26-2017, 05:15 PM
FlameRetired Re: Using the same Data set... 05-26-2017, 08:17 PM
  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