Sumproduct for 1 date and text condition

[JimmyG.]

I am trying to pull statistics together from data that is entered through a user form.
There will be multiple entries for each day and I want to total the results, an example of this is below:

cell.png

Date Called Before Caller Date Yes Customer
01/07/2013 10:00 Yes Customer 01/07/2013 2 1
01/07/2013 10:10 Yes Staff 02/07/2013 1 1
01/07/2013 11:13 No Staff 03/07/2013 1 1
02/07/2013 02:30 Yes Staff 04/07/2013 1 0
02/07/2013 15:38 No Customer
03/07/2013 13:00 Yes Customer
04/07/2013 16:55 Yes Staff

I am using the sumproduct formula: =SUMPRODUCT(--($A$2:$A$8>=E2+0)*($A$2:$A$8<=E3+0)*($B$2:$B$8="Yes"))
which does seem to work, however when I get to the end of the list I get a problem as there is no next date. Rather than using >= and <= for the date, is there a way to have it so it is just = to a date?
I may need to combine the criteria later on, ie on 01/07/13 how many staff called that have not called before (answer 1)

If someone can provide me with a simpler sumproduct formula it would be greatly received.

[JBeaucaire]

Same idea:

=SUMPRODUCT(($A$2:$A$8=E3+0)*($B$2:$B$8="Yes"))

[JimmyG.]

Hi JB, that is what I thought too but when I try it I get a 0 result even though there should be an answer. Any ideas?

[bharat_shady]

=sumproduct((Range1= Criteria1)*1,(Range1= Criteria2)*1,(array1,array2))

OK and Tested on multiple models

[JimmyG.]

Hi Bharat, thank you for the reply however I can't seem o figure it out - what would I put in where it says array1,array2?

[JBeaucaire]

Ah, I see, your reference data has TIMES in it, the match date does not. Try this:

=SUMPRODUCT((INT($A$2:$A$8)=INT(E3)+0)*($B$2:$B$8="Yes"))

[JimmyG.]

Hi JB,
Thanks for the update that works great.

If you could, do you mind explaining the difference with TIMES and MATCH, also what the difference is with the -- and INT?

Thank you

Ah, I see, your reference data has TIMES in it, the match date does not. Try this:

=SUMPRODUCT((INT($A$2:$A$8)=INT(E3)+0)*($B$2:$B$8="Yes"))