I have the following in a workbook:

Sheet1 - 3 Columns

1/1/2006 1 A
1/2/2006 2 B
1/1/2006 3 C
1/2/2006 4 A
1/2/2006 5 B


Sheet2 - 1 Column, 2 Rows

1/1/2006
<insert function(s) here

Using function(s), without VBA, is it possible to get the total number of
rows for the date specified in Sheet2!A1 that also have a text value which
is 'A'?

The count, dcount, and countif functions allow for a single condition (or
more than 1 condition), for a single set of values (range)...in my case,
there are 2 sets of values to check for the count...

I hope it's possible :)

Thanks,
Mythran