+ Reply to Thread
Results 1 to 3 of 3

How do I use Sumproduct to count three conditions

  1. #1
    Registered User
    Join Date
    03-14-2005
    Posts
    1

    How do I use Sumproduct to count three conditions

    I am trying to count the amout of tickets in a certain region that are of a Sev1 level and <24 hrs. old, but can't seem to get the function to work for me. Below is the function I am trying.

    =SUMPRODUCT((Report!H2:H89="SW")*(Report!C2:C89<=24)*(Report!D2:D89=1),Report!A2:A89)

    I am hitting Shift+Ctrl+Enter.

    What I recieve is a 0 even though I know there is tickets fitting those conditions.

    Ticket # Hours Open Severity Region
    1 4.7 1 SW

    Any ideas would be great..

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    The formula looks correct.

    - Mangesh

  3. #3
    Forum Contributor
    Join Date
    09-05-2004
    Location
    Melbourne
    Posts
    193
    There is no need to hit CTRL+SHIFT+ENTER on this formula. It could be re-written this way but both should work.

    =SUMPRODUCT(--(H2:H89="SW"),--(C2:C89<=24),--(D2:D89=1),A2:A89)

    If you are using a version of Excel that has Formula Auditing, you could Evaluate your formula and see what the results are for each step. I would confine your range to 3 rows for this for ease of reviewing your formula if you try this.

    Cheers!

+ Reply to Thread

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