Results 1 to 6 of 6

Sumproduct when 1 array has multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2019
    Location
    Montreal
    MS-Off Ver
    version 10
    Posts
    5

    Sumproduct when 1 array has multiple criteria

    Hello

    I would like to know if there is a work around to the following issue.

    I have attached a spreadsheet of a short list for reference

    I would like to use sumproduct (preferably over sumifs) to add the expenses for various departments

    I am currently using the following formula
    =SUMPRODUCT((GL=$T$5)*(DEPT=$T$2)*(DATE=U$4)*BUDGET)+SUMPRODUCT((GL=$T$5)*(DEPT=$T$3)*(DATE=U$4)*BUDGET)

    I would like to eliminate the second part of the formula +SUMPRODUCT((GL=$T$5)*(DEPT=$T$3)*(DATE=U$4)*BUDGET) and include many departments in the DEPT Array.

    (In my original list I have over 20 departments and cannot remove the DEPT ARRAY because it ties into other issues in my spreadsheet)

    Any help is greatly appreciated
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine sumif/sumproduct or sumproduct with multiple criteria
    By sab128 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2018, 08:25 AM
  2. SUMPRODUCT or SUMIF using an array for criteria
    By rarascon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2013, 03:14 PM
  3. [SOLVED] Sumproduct - 2 criteria with different array sizes
    By Lacaycer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-03-2012, 02:24 PM
  4. Replies: 5
    Last Post: 04-20-2012, 08:54 AM
  5. Replies: 3
    Last Post: 01-07-2012, 02:51 AM
  6. Sumproduct or array formula for counting criteria of sum of cells
    By jasoncw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-09-2007, 03:09 PM
  7. Replies: 5
    Last Post: 06-14-2006, 07:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1