Results 1 to 7 of 7

Sumproduct with multiple conditions help

Threaded View

Murphy15 Sumproduct with multiple... 07-31-2013, 03:10 PM
Ace_XL Re: Sumproduct with multiple... 07-31-2013, 03:16 PM
NeedForExcel Re: Sumproduct with multiple... 07-31-2013, 03:16 PM
XOR LX Re: Sumproduct with multiple... 07-31-2013, 03:16 PM
daddylonglegs Re: Sumproduct with multiple... 07-31-2013, 03:18 PM
Murphy15 Re: Sumproduct with multiple... 07-31-2013, 03:21 PM
NeedForExcel Re: Sumproduct with multiple... 07-31-2013, 03:28 PM
  1. #1
    Registered User
    Join Date
    07-31-2013
    Location
    Emeryville, CA
    MS-Off Ver
    Excel 2003/07/10
    Posts
    34

    Sumproduct with multiple conditions help

    Hey all need help with a sumproduct formula.

    I am doing my company's expense report. The expenses are broken down by the pay period the expense was paid, the amount, the code which the expense is under, the name of the code, and the department the expense goes to. (Attached document)

    For some reason my Sumproduct formula is not working I keep getting $0 when there is suppose to be another number

    =SUMPRODUCT(--($A$1:$A$14>=$G$2),--($A41:$A$14<=$G$3),--($C$1:$C$14="530"),--($C$1:$E$14="M"),--($B$1:$B$14))

    But when I use this other formula to get the total of all billable and all NonBillable It works

    =SUMPRODUCT(--($A$1:$A$14>=$G$2),--($A$1:$A$14<=$G$3),--(D1:$D$14="Billable")--($E$1:$E$14="M"),--(B1:B14))

    Does the formula not like specifc numbers to look for or is it something else?

    Thanks
    Attached Files Attached Files
    Last edited by Murphy15; 07-31-2013 at 03:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple (3) SUMPRODUCT conditions
    By timjames in forum Excel General
    Replies: 2
    Last Post: 11-03-2011, 03:17 PM
  2. Multiple conditions in one column for sumproduct.
    By einarai in forum Excel General
    Replies: 4
    Last Post: 08-07-2011, 04:01 AM
  3. Sumproduct - Using multiple conditions
    By EXCELNEWCOMER in forum Excel General
    Replies: 5
    Last Post: 02-11-2010, 04:43 PM
  4. Sumproduct - multiple conditions
    By rasonline in forum Excel General
    Replies: 10
    Last Post: 06-04-2009, 05:10 PM
  5. Sum with multiple conditions:SUMPRODUCT
    By will.00 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2007, 03:51 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