View Single Post
  #5   Report Post  
Cutter
 
Posts: n/a
Default


Assuming you want to exclude values that equal 90 and 110, try this:

=COUNTIF(A1:A100,"90)-COUNTIF(A1:A100,"109")

Change the range A1:A100 to suit your needs


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=466499