B
Bob Flanagan
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
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