+ Reply to Thread
Results 1 to 4 of 4

Sumproduct using multiple criteria

Hybrid View

sabiza Sumproduct using multiple... 04-18-2018, 08:44 AM
JohnTopley Re: Sumproduct using multiple... 04-18-2018, 10:21 AM
sabiza Re: Sumproduct using multiple... 04-27-2018, 10:47 AM
JohnTopley Re: Sumproduct using multiple... 04-27-2018, 10:52 AM
  1. 04-18-2018, 10:21 AM #1
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,699

    Re: Sumproduct using multiple criteria

    This will get your result but you need to change highlighted range for other columns

    =SUMPRODUCT(SUMIF(INDIRECT("'"&UK&"'!B13:B29"),$B19,INDIRECT(UK&"!D13:D29")))

    Copy down
    Last edited by JohnTopley; 04-18-2018 at 01:41 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Sum based on multiple criteria using sumproduct: One criteria is 'cell contains'.....
    By jeroenv in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2018, 08:18 AM
  2. [SOLVED] SUMPRODUCT of multiple columns with multiple criteria over multiple sheets
    By BellyGas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2015, 08:27 AM
  3. [SOLVED] Multiple criteria SUMPRODUCT (3 criteria) Excel 2003
    By lelrich in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2014, 01:58 PM
  4. Sumproduct to count number of times multiple criteria are met across multiple spreadsheets
    By Victoria6517 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2014, 09:09 PM
  5. SUMPRODUCT: Multiple criteria in same column and criteria NOT hard coded
    By Asmar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-04-2013, 11:53 AM
  6. [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
  7. Sumproduct/sumif/indirect across multiple workbooks, worksheets, multiple criteria
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 02:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1