+ Reply to Thread
Results 1 to 4 of 4

SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &

  1. #1
    Registered User
    Join Date
    10-15-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    77

    SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple rows &

    Hi All,

    I need a formula (presumably SUMPRODUCT) to sum a range that consists on multiple rows and columns, with multiple criteria accross several rows and columns.

    I have attached an example workbook, colour coding the criteria to the criteria range.

    Any help would be greatly appreciated

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,132

    Re: SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple row

    One way,
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-15-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    77

    Re: SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple row

    Worked perfectly, thank you very much.

  4. #4
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,132

    Re: SUMPRODUCT (sum range has multiple rows & columns, and criteria is across multiple row

    You are welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct Count multiple criteria with range over multiple rows and columns
    By 77highland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2023, 05:19 PM
  2. [SOLVED] Sumproduct across multiple rows/columns/criteria
    By jrashton92 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2020, 01:21 PM
  3. [SOLVED] Lookup multiple criteria in multiple columns in multiple rows; return true if exists
    By ufdlim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 02:03 PM
  4. [SOLVED] Sumproduct Across Columns and Rows with multiple criteria
    By NainaH in forum Excel General
    Replies: 7
    Last Post: 01-31-2019, 11:26 AM
  5. Replies: 1
    Last Post: 08-16-2015, 08:59 AM
  6. [SOLVED] Sumproduct for multiple criteria across columns and rows
    By yacatac in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-12-2015, 07:46 AM
  7. Replies: 1
    Last Post: 05-18-2009, 11:21 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