Countif using Greater than and cell reference
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)