Simple formula

[Peter1973]

I have tried everything but can't seem to get my formula to work I know it is probably a simple one.

I have various numbers in cells J7:DX7 I want my formula to count how many of these numbers are greater than the number in cell B7.

I know probably not very challenging..

 

[Richard Schollar]

Hi Peter

=COUNTIF(J7:DX7,">"&B7)

Best regards

Richard

 

[Peter1973]

Thanks I had my arguments mixed up.