> 
> I would like to count the records in a database using a NAME text criteria
> from column A and a DATE date criteria from column B.  I tried
> COUNTIF("NAME","John")("DATE","<"&1/1/97),
> COUNTIF("NAME","John") AND ("DATE","<"&1/1/97),
> COUNTIF(A:A,"John")(B:B,"<"&1/1/97) with no luck.  Is there some way I can
> type a formula that counts records using two fields with different formats
> as the criteria?  Thank you for your help.


array enter (i.e., enter with Ctrl+Shift+Enter instead of just Enter)
the following:

	=SUM(IF((B1:B10