Count/if/and function?
On Mar 25, 3:00*pm, Pete_UK wrote:
If your cells are in column A, then try this:
=COUNTIF(A:A,"1")
Hope this helps.
Pete
On Mar 25, 7:43*pm, tonyalt3 wrote:
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 -
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?
|