Sumproduct using dates

[miguelre]

In the past have been successful using the sumproduct to count based on multiple criteria. However, I can not get it to successful work with my date field that I am importing. Example of calculation below.

=SUMPRODUCT((AllStatusDetail!$E$4:$E$3205="Vanessa Rogers - CC&B")*(AllStatusDetail!$D$4:$D$3205="Y")*(AllStatusDetail!$F$4:$F$3205="9/15/2006 5:00:00 PM"))

 

[onlyadrafter]

Hello,

It works on mine, are there any spaces at the end of the date?

 

[Aladin Akyurek]

In the past have been successful using the sumproduct to count based on multiple criteria. However, I can not get it to successful work with my date field that I am importing. Example of calculation below.

=SUMPRODUCT((AllStatusDetail!$E$4:$E$3205="Vanessa Rogers - CC&B")*(AllStatusDetail!$D$4:$D$3205="Y")*(AllStatusDetail!$F$4:$F$3205="9/15/2006 5:00:00 PM"))

If you really need the time bit...

=SUMPRODUCT(--(AllStatusDetail!$E$4:$E$3205="Vanessa Rogers - CC&B"),--(AllStatusDetail!$D$4:$D$3205="Y"),--(AllStatusDetail!$F$4:$F$3205="9/15/2006 5:00:00 PM")+0)

If not...

=SUMPRODUCT(--(AllStatusDetail!$E$4:$E$3205="Vanessa Rogers - CC&B"),--(AllStatusDetail!$D$4:$D$3205="Y"),--(AllStatusDetail!$F$4:$F$3205="9/15/2006")+0)

Note that using a coercer like -- (double negation) allows you to invoke SumProduct with its native comma-syntax.