Hi
if you also want to count values which only have for example 'one' as part
of the first column (e.g. 'this is one') then use
=SUMPRODUCT(--ISNUMBER(SEARCH("one",A1:A100)),--ISNUMBER(SEARCH("two",B1:B100)),--(C1:C100<DATE(2004,12,1)))

If one or two have to be the complete entry of the cell use
=SUMPRODUCT(--(A1:A100="one"),--(B1:B100="two"),--(C1:C100<DATE(2004,12,1)))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany
"shmurphing" schrieb im Newsbeitrag
...
Can anyone tell me how to performt he following?

I want to count the cells in column A that contain the word "One" and then
count the cells in column B that ALSO contain the word "Two" and then
count
the cells the ALSO are less than a specific date. The count at the end
will
indicate that the row had one, two, and was less than dec 1, 2004.

Help!