View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] linda.taylor@ingenix.com is offline
external usenet poster
 
Posts: 2
Default Using COUNTIF with AND

This should be pretty easy; it's a little embarrasing to ask. I'm
trying to count all cells with a value within a specified range. It's
not working. Here is the formula I'm using:

=COUNTIF(A1:A17,(AND(A1:A173,A1:A17<6)))

Where am I going wrong?