Thread: I have a column of numbers, some positive, some negative.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donald Guillett Donald Guillett is offline
external usenet poster
  
Posts: 36
Default I have a column of numbers, some positive, some negative.
On Mar 23, 8:09*am, Skip wrote:
I would like to count the number of entries that are 3 and are <=7.
What function would I use? *Thanks for any help.

In xl 2007 look in the help index for countIFS. In less than xl 2007
look in the help index for COUNTIF and AND
Reply With QuoteReply With Quote