Thread: complex formula
View Single Post
  #7   Report Post  
shmurphing
 
Posts: n/a
Default

Wow! This works great. Think I should be able to take care of the rest of
the spreadsheet with ease.

Thank you - Happy Holidays!

"shmurphing" wrote:

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!