Results 1 to 4 of 4

SumProduct on Multiple Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    48

    SumProduct on Multiple Criteria

    I got a question why the sumproduct can not detect the value on the second cateria that i want

    =SUMPRODUCT(($D$2:$D$15="Cash")*($E$2:$E$15="1"))
    but it give me zero suppose have 1. Why like this ? Please help
    Date Invoice Company ID Method Amount
    15/01/2008 110187 Check 57.62
    16/01/2008 110188 Cash 1.00
    16/01/2008 110189 CC 23.74
    16/01/2008 110190 Check 49.12
    17/01/2008 110191 Check 17.35
    18/01/2008 110192 CC 62.95
    18/01/2008 110193 Cash 1.41
    18/01/2008 110194 Check 23.62
    19/01/2008 110195 Check 58.83
    20/01/2008 110196 Check 81.07
    20/01/2008 110197 Check 51.31
    21/01/2008 110198 CC 36.92
    21/01/2008 110199 Cash 82.68
    21/01/2008 110200 CC 53.41
    Last edited by Cutter; 07-21-2012 at 11:52 AM.

Thread Information

Users Browsing this Thread

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

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