Both the formulas can be reduced and the same is given below:-

Use this formula for finding the values in A&B Column which is GREATER than
C1 Cell:-
=IF(COUNTIF(A:B,""&$C$1)<=0,"1",COUNTIF(A:B,""&$ C$1))


Use this for formula for finding the values in A&B Column which is LESS than
C1 Cell:-
=IF(COUNTIF(A:B,"<"&$C$1)<=0,"1",COUNTIF(A:B,"<"&$ C$1))

If this post helps, Click Yes!

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



"Ms-Exl-Learner" wrote:

Use this formula for finding the values in A&C Column which is GREATER than
C1 Cell:-
=IF(COUNTIF(A:A,""&$C$1)+COUNTIF(B:B,""&$C$1)<=0 ,"1",COUNTIF(A:A,""&$C$1)+COUNTIF(B:B,""&$C$1 ))


Use this for formula for finding the values in A&C Column which is LESS than
C1 Cell:-
=IF(COUNTIF(A:A,"<"&$C$1)+COUNTIF(B:B,"<"&$C$1)<=0 ,"1",COUNTIF(A:A,"<"&$C$1)+COUNTIF(B:B,"<"&$C$1 ))

If this post helps, Click Yes!

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



"RobertK" wrote:

The countif formula works fine except that if the date in column A and the
date in column B are both less than C1, I don't want to count it each time.
I only want to count it as one. Does this explanation help.
--
Robert K


"Ms-Exl-Learner" wrote:

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