Countif using Greater than and cell reference

I need to count the number of times a date in Table 2 is greater than a date in Table 3. I can do this if I manually insert the conditional date in my formula (i.e. ">1/20/10"), but I can't seem to get the formula to recognize the condition when I'm referencing another cell (i.e. Table 3, cell A2).

TABLE 2
Date Cond 1 Cond 2
1 2/1/10 Y Y
2 1/18/10 N N
3 12/16/09 N Y
4 1/10/10 N N

TABLE 3
A
1
2 1/20/10

=COUNTIF(Table 2 :: C2:C194, ">A2")

I'm having problems with the above formula ">A2". I can replace A2 with a date and it works, but I can't seem to reference cell A2 with a greater than sign and have the formula work. Please help.

Mac, Mac OS X (10.6.2)

Posted on Feb 15, 2010 3:18 PM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Countif using Greater than and cell reference

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.