Count formula

[Sue]

I am trying to count how many record there are that match the date in
Flash!s2 and match location in flash B6. The formula works in out scenarios
that are not involving the date. So I am assuming I need to do something
different on the date? Trls H1:H5709 are date fields as well as the date in
Flash S2.


=SUMPRODUCT(('Trls'!$H$1:$H$5709=Flash!S2)*('Trls'!$B$1:$B$5709=Flash!$B6))

 

[Bob Phillips]

=SUMPRODUCT(--(trls!$H$1:$H$5709<>""),--(trls!$H$1:$H$5709=Flash!S2),--(trls!$B$1:$B$5709=Flash!$B6))

 

[Sue]

I cut and pasted your formula, I do not get an error, but it does not but it
does not count the items either, it just returns 0. Any other ideas on what
I should check?

 

[Sue]

Never mind, it was a stupid typo on my part on the date. Thanks it works
great.