This formula does what you want:

=SUMPRODUCT(--(A2B$2:B$5))

where the heading Data1 is in A1, Data2 in B1 and Value in C1 - put
the formula in C2, adjust the ranges to suit your real data, then copy
down.

Hope this helps.

Pete

On Jul 31, 7:31*pm, Rocky4460
wrote:
Can anyone suggest a formula for this?
Basically, I'm trying to find out how many times does a number on the data 1
column exceed the numbers on the data 2 column.

Data 1 * * Data 2 * * * * * * Value
4 * * * * * * * *3
5 * * * * * * * *18
10 * * * * * * *1
4 * * * * * * * 2

The result should say for the 'value' column 3, since 4 3,1,2 but less than
18
similiarly for 5, the result should be 3 and so on.

Thanks, I tried the countif method, but does not help.