Formula fails to address a range in another sheet

Formula fails to address a range in another sheet

I was experimenting with the following COUNTIF formula which works fine when used on the same sheet;

=COUNTIF(B$12:B$10004;A4)

However, if I address the same range in another sheet, it fails to return a result, i.e.;

=COUNTIF(LOG.B$12:B$10004;A4)

What am I doing wrong ?