+ Reply to Thread
Results 1 to 5 of 5

Multiple conditions in one column for sumproduct.

Hybrid View

  1. #1
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Multiple conditions in one column for sumproduct.

    For SUMIFS the dimensions of each range must be identical.

    Here it seems you have 2 criteria columns which are 1 column wide therefore your summation range must also be 1 column wide.
    You would need to create 2 separate SUMIFS - one for each column of the summation range - this is not ideal obviously
    (in fact you would be running 4 SUMIFS - PM x 2, NM x 2)

    You may then choose to revert to SUMPRODUCT, perhaps along the lines of:

    =SUMPRODUCT(ISNUMBER(MATCH(DXB!A3:A3000,{"PM","NM"},0))*(DXB!C3:C3000=1)*{1,1},DXB!G3:H3000)
    the above would handle non-numerics in G3:H3000 (avoids explicit coercion of summation range)

    else consider adding a total column which sums G:H and use that in the SUMIFS.
    Last edited by DonkeyOte; 08-07-2011 at 03:38 AM. Reason: typo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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