Why aren't my If statements consistent?

In my excel file, I am trying to determine if a set of numbers is greater than the value of another cell.

I have written out an IF statement that only works sometimes depending on the range of the set of numbers. I have been able to replicate the problem but can't understand what is going wrong. I have included an example of my problem.

"B4" is equal to 2

"'Data Sheet'!A1:A10" is a set of 10 numbers from 1 to 10 inclusive.

My first statement (seen below) is working fine:

=IF(B4>'Data Sheet'!A1:A10,"Pass", "Fail")

which returns Fail, as expected.

However, when I change the statement to:

=IF(B4>'Data Sheet'!A6:A10,"Pass", "Fail")

It returns "#VALUE!".

Why does the range of values in the IF statement make a difference to whether it works or not?