Calculating Occurrences

[deadringer]

I want to calculate the occurrences of a value in one column, if a certain value is in a second and also a third column. I know how to do this is I am calculating the occurrences of TEXT:

=SUMPRODUCT(--(A:A="text"),--(B:B="text"),--(C:C="text"))

But how would I do this if 2 columns are text and the third one is a date (dd/mm/yyyy hh:mm)?

 

[Special-K99]

Try

=SUMPRODUCT(--(A:A="text"),--(B:B="text"),--(C:C=DATEVALUE("29/10/1961 10:00"))

 

[deadringer]

The results are returning as "0" (???)

 

[deadringer]

Okay, I got your formula to work. It was the timestamp througing it off. Once the timestamp was removed, it worked perfectly.

However, I need this to calculate occurances regardless of the timestamp - and I'd like to not have to remove the timestamp.

Is ther a formula that will calculate the occurances regardless of timestamp?