Brian,

This formula should work:

=COUNTIF(B2:B9,"4")

----
Regards,
John Mansfield
http://www.pdbook.com


"Brian" wrote:

I have values in cells B2:B8. In cell B10, I woud like a formula that counts
the number of cells in B2:B9 with values greater than 4. Thanks for your
assistance.