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.
Bookmarks