I would like to count how many cells only IF they contain a value
greater than 1. Is this possible?- Hide quoted text -

- Show quoted text -

If your cells are in column A, then try this:

=COUNTIF(A:A,"1")

Hope this helps.

Thanks Pete, but I need to make sure it does NOT count any cells w/
zeros in it. This seems to still count them. Any other suggestions?

Did you try it? It works fine on my system.

Note, Pete is suggesting COUNTIF, not COUNT.

Rick