I am confused...

Please check the data and your query once again.

Your Wordings:-
In the example below 9 dates meet the criteria (8 in column A and 1 in
column B)

But if you see the example once again you will notice that two dates in A
column (1-Mar-10 & 1-Jan-10) is greater that C1 Cell (i.e.) 16-Sep-09. So
the Number of dates greater than C1 count is 2.

Your Wordings:-
In the example below 9 dates meet the criteria (8 in column A and 1 in
column B)

I dont know how you have calculated one date in Column B because all the
dates are less that c1 cell.

Please once again explain your query with clear picture.

If you want to count the A&B Column values which is GREATER than C1 cell
then use this formula:
=COUNTIF(A:A,""&$C$1)+COUNTIF(B:B,""&$C$1)

If you want to count the A&B Column values which is LESS than C1 cell then
use this formula:
=COUNTIF(A:A,"<"&$C$1)+COUNTIF(B:B,"<"&$C$1)

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"RobertK" wrote:

I have a spreadsheet similar to this. I need to count the number of dates in
column A that are less than C1. If the date in column A is greater than C1
than I want to count the date in column B if it is less than C1. If the date
in column A & B are both less than C1 they should count as 1 and not 2. In
the example below 9 dates meet the criteria (8 in column A and 1 in column
B). Also the database length will vary and will contain blank cells after
the last entry in column A.

A B C
1/2/2009 3/2/2008 9/16/2009
3/2/2009 6/5/2008
6/5/2008 9/4/2008
3/1/2010
1/1/2010 4/1/2009
7/5/2009
9/15/2008 9/15/2009
12/4/2008
11/4/2008



2/12/2009
3/12/2010


--
Robert K