+ Reply to Thread
Results 1 to 3 of 3

Formula to Sumproduct with multiple criterias

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    Alabama
    MS-Off Ver
    Excel 2010
    Posts
    14

    Formula to Sumproduct with multiple criterias

    Hello,

    I am trying to get to a composite rate that has different sites, different weights and different contractors.

    I tried the following formula but it would not take:

    =sumifs(sumproduct(B9:B21,F9:F21),C9:C21,"X")+sumifs(sumproduct(D9:D21,F9:F21),E9:E21,"X")

    See attached. Formula should go in the highlighted cell.

    Thanks for all the help I can get.
    Attached Files Attached Files

  2. #2
    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
    27,994

    Re: Formula to Sumproduct with multiple criterias

    Try

    =SUMPRODUCT((B9:B21)*(F9:F21)*(C9:C21="X"))+SUMPRODUCT((D9:D21)*(F9:F21)*(E9:E21="X"))

  3. #3
    Registered User
    Join Date
    09-19-2013
    Location
    Alabama
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Formula to Sumproduct with multiple criterias

    Hi John,

    I can't believe it was that easy!

    Thanks again for your help.

+ 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. IF formula or multiple criterias
    By Doongchen in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2016, 10:32 PM
  2. Sumproduct for ranking with multiple criterias; maybe sumifs?
    By myth_victor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2015, 10:44 AM
  3. [SOLVED] How to ignore zero values in sumproduct with multiple criterias
    By malcolmc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2014, 12:06 AM
  4. [SOLVED] Sumproduct multiple criterias with dates?
    By preddy1110 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2014, 07:51 AM
  5. [SOLVED] Sumproduct with multiple criterias
    By JERICA in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-04-2013, 07:09 PM
  6. [SOLVED] How to build a SumProduct with multiple criterias.
    By gouleta in forum Excel General
    Replies: 4
    Last Post: 06-04-2012, 12:23 PM
  7. multiple criterias in SUMIF formula
    By aysrun in forum Excel General
    Replies: 8
    Last Post: 07-29-2009, 02:40 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