COUNTIF in named Table: Column X > Column Y

[ajbatts]

Hi Guys,

I've got a table with data I need to count. I've successfully done this in a column and set the criteria and it works:

=COUNTIF(Table5[@[%]],">79%")

However I'm stuck trying to get the formula criteria to work to count when one column in the table is greater than another

=COUNTIF(Table5[@£],">Table5[@£LW]")

As you can see from the formula, it's a named table with headers but the 2nd formula (regardless of which column) doesn't work.

Any suggestions?

[Special-K]

This works.
Define one column in the table as Name1 and another column as Name2
then use

=COUNTIF(Name1,">Name1")
Array formula, use Ctrl-Shift-Enter

[:) Sixthsense :)]

Try this...

=COUNTIF(Table5[£],">"&Table5[@£LW])

[ajbatts]

Thanks - I'll try renaming the table as a last resort.

Special-K the =COUNTIF(Table5[£],">"&Table5[@£LW]) formula generates a return but the Table5[£] reference returns all cells in that column which are over the one cell value in ">"&Table5[@£LW]). So instead of getting a 0 or 1 returns 24 that are above that figure.

[ajbatts]

Got it by adding the @ back in - the rearrangement you suggested of the " did the trick thanks

=COUNTIF(Table5[@£],">"&Table5[@LW])