Hi,

Try this

=SUMPRODUCT((A1:A100=DATE(2008,1,1))*(B1:B100="My Search Criteria"))

or if you search criteria is a number

=SUMPRODUCT((A1:A00=DATE(2008,1,1))*(B1:B00=nnn))

It would hawever be far more flexible if you used cell references in your
formula

=SUMPRODUCT((A1:A00=C1)*(B1:B00=C2))
Where C1 is the date and C2 is your search criteria.

Mike

"Scott" wrote:

I have a spreadsheet with multiple column data sorted by date. I am looking
to create a report that will count the number of text occurances on a given
date. For instance, there are 36 occurances of the search criteria in Column
B on January 1st. Any ideas?