formula for countIf with two conditions
I need to count the number of cells in a range that are
less than 100 (some values may be negative)
Not empty (ie, exclude blanks)
Not zero
The last requirement is what is causing me the headache. A CountIF ignores
the blanks, but I can't figureout how to add a second condition for the not
zero requirement.
thanks
Bob
|