Benches Uncategorized

3

Countif using Greater than and cell refer…

apple Verified

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.

  1. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Welcome to the Numbers Discussion Forum.

    The condition should be written as ">"&A2

  2. 0

    MGLeach

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Works perfectly. Thanks...

  3. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You're welcome.