countif

[freekrill]

Can somebody help me with a countif function which counts the number o
values in cells A1:A10, which have a value which is greater than tw
times the value in B1?

This is what I have tried but it doesn't work:

=countif(A1:A10,>2*B1)

Thanks for any assistance

fre

 

[Biff]

Try this:

=SUMPRODUCT(--(A1:A10>B1*2))

Biff

 

[Jack Schitt]

=COUNTIF(A1:A10,">"&2*B1)

HTH