Sheet 1 has an X column that has dates. It also has column BD that has a
"Yes" or "No" entered in it. The cell range is from 2-221. On sheet 2, I
want to count the number of "no" entries in BD for only the records where the
date in X is greater than 1/1/2006.

My formula is this :
=COUNTIF(Sheet1!X2:X221,"1/1/2006",Sheet1!BD2:BD221,"no")

I can get the countif function to do each separately, but I don't know how
to combine the two.

Help!

Thank you.