Results 1 to 8 of 8

Subtotal with Multiple SUMPRODUCT Criteria

Threaded View

  1. 05-24-2022, 05:59 AM #1
    singerbatfink
    singerbatfink is offline
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2016
    Posts
    143

    Subtotal with Multiple SUMPRODUCT Criteria

    Hi, Im trying to add subtotal to my formula in column K & L rows 4 to 10 so the results only show for a selected date. The date can be selected from the dropdown in R1.
    Can anyone help. Sample file attached.

    Regards B
    Attached Files Attached Files
    Last edited by singerbatfink; 05-24-2022 at 06:52 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumproduct with subtotal with offset with multiple criteria - trying to "reversengineer"
    By KIGeorge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-15-2020, 11:31 PM
  2. How to use the SUMPRODUCT Subtotal formula based on TWO criteria
    By Fireflies827 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-15-2020, 11:50 PM
  3. [SOLVED] sumproduct subtotal offset with multiple criteria
    By reneevic in forum Excel General
    Replies: 10
    Last Post: 07-02-2019, 04:57 PM
  4. [SOLVED] Nest SUMPRODUCT with SUBTOTAL with 3 criteria
    By sick stigma in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2019, 01:23 PM
  5. How to use subtotal in sumproduct with multiple criteria
    By Daniel Tou in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2017, 05:11 AM
  6. [SOLVED] Sumproduct, Subtotal with multiple condition
    By ravi.jalani in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2013, 12:18 PM
  7. [SOLVED] Sumproduct with Multiple (Header) Criteria - Sumproduct, Index, Match
    By dluhut in forum Excel General
    Replies: 5
    Last Post: 04-20-2012, 08:54 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1