+ Reply to Thread
Results 1 to 2 of 2

Sum product with long string

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Sum product with long string

    Spent about 5 hours pulling my hair out just cant seem to get the formula to work.

    Column B contains my reference Date
    Column C contains Date
    Column O contains a specfic Text string

    Formula I have is:

    =SUMPRODUCT(Data!$C$2:$C$3474=B3)*(Data!$O$2:$O$3474="Dialed into IVR, Prompted for number, Unmatched, Hung Up") returns 0
    also

    =SUMPRODUCT(--Data!$C$2:$C$3474=B3)--(Data!$O$2:$O$3474="Dialed into IVR, Prompted for number, Unmatched, Hung Up") returns 1

    Need it to look up how many occurrances of "Dialed into IVR, Prompted for number, Unmatched, Hung Up" appear in 'column C' on a date I specify in cell B3

    first section seems to work fine but then fails when looking up the second argument. is the string to long?

    Please help.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Sum product with long string

    It seems 1 pair of bracket has been missed:
    =SUMPRODUCT((Data!$C$2:$C$3474=B3)*(Data!$O$2:$O$3474="Dialed into IVR, Prompted for number, Unmatched, Hung Up"))
    Quang PT

+ 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