Thanks for your kind efforts anyway.

It has to count value in Column A in a specified time that is recorded in
Column B.

regards,
--
Toronto


"Sheeloo" wrote:

Use
=COUNTIF('Consolidated Sheet'!G:G,""&DATE(2009,1,1))

It has nothing to do with values in Col A...
Will give you the count in G where date is 1/1/2009

"observer" wrote:

Thanks Sheeloo for prompt support.

However it counted the all records, not only specified and met the condition
but all those records that were in A:A column.

Do you have alternative suggestions.


--
Toronto


"Sheeloo" wrote:

Enter the date 1/1/2009 in G1 of 'Consolidated Sheet' and use
=COUNTIF('Consolidated Sheet'!A:A,""&'Consolidated Sheet'!$G$1)

"observer" wrote:

Request for Help

Trying to count DATA in A:A
Condition is that the DATE that is later than 01-01-2009 in G:G
with this and lots of variations of the following formul:

=COUNTIF('Consolidated Sheet'!$A:$A,'Consolidated Sheet'!$G:$G=("01
January 2009")1)


Toronto