Here is what I've come up with but it doesn't work:

=SUMPRODUCT(
([sold.xls]main!$X:$X="ccc")*([sold.xls]main!$ac:$ac="9/23/06"))

I need to count the number of rows that have
1) the letters "ccc" in column X and
2) the date in column AC

Please help!