Thread: values greater than and including
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default values greater than and including
=SUM(COUNTIF(A:A,{"=6","=12"})*{1,-1})


"Teeny" wrote:

I need to find how many values in a column are greater than and including 6
but less than 12, I have tried many variations on COUNTIF and the numbers
just dont look right.

Can anyone help?
Reply With QuoteReply With Quote