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?