Very Easy - Countif problem

[khbutts]

Trying to do this:

=COUNTIF(B4:B87, ">B$122")

but it looks like it won't work with a reference as the criteria....anyone know of a different formula to accomplish what I am trying to do?

Maybe it will require the sumproduct formula?

Thanks!

 

[Andrew Poulsom]

Try:

=COUNTIF(B4:B87, ">"&B$122)

 

[BrianM]

Try this:
=SUMPRODUCT(--(B4:B87>B122))

 

[khbutts]

Thanks, guys....Andrew Poulsom's suggestion worked perfectly....it's sad how bad Excel help blows, but if it was good, we wouldn't have Mr. Excel, I guess!