Countif using Greater than and cell refer…
Imported from the Apple Support Forums via the Wayback Machine 🔗
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.
3 replies
Sign in or join Beachball Help to reply.
- 0
- 0
- 0