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

formula for countIf with two conditions
 

=COUNTIF(A1:A100,"<100")-COUNTIF(A1:A100,0)
--
Gary''s Student - gsnu2007d

formula for countIf with two conditions
 

=SUMPRODUCT((A1:A100<100)*(A1:A100<0))


"Bob Flanagan" wrote:

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