=SUMPRODUCT(--(DateRange=Date),--ISNUMBER(CashRange))

=SUMPRODUCT(--(DateRange=Date),--ISNUMBER(CheckRange))

Ranges cannot refer to whole columns like A:A in this type of formula.

Jerry W wrote:
I know this has probably been addressed but cant locate my specific issue:
I would like to count entries in columns b & c that meet criteria in column
a. Here is an example:
Date Cash Check
01/19/05 2.00
01/19/05 5.00
01/19/05 5.00
01/19/05 3.00
02/28/05 1.00
02/28/05 2.00

What formula would give these counts as the end result?:
01/19/05 2 2
02/28/05 1 1
Thanks - Jerry