Why are you counting column A if your criteria is column G?

Have to convert the date to a serial. (1-1-09 = 39814 [can be found easily
in XL by typing a date, then formatting cell as number])
=COUNTIF('Consolidated Sheet'!$G:$G,"39814")

If you're actually needing some criteria in A, you can use COUNTIFS if you
hx XL 2007, or just use SUMPRODUCT like this
=SUMPRODUCT(('Consolidated Sheet'!A1:A65536="My Criteria")*('Consolidated
Sheet'!G1:G6553639814))

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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