Note: Mine assumes that the criteria you're looking to count remains in place
on the DATA tab. bpeltzer's formula assumes you've moved the criteria onto
that cell on the LIST tab.

"Eric" wrote:

On LIST:

=COUNTIF(DATA!E2:E50000,DATA!I2)