Thread: How do I use the count if function for a range from 40-60 ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default How do I use the count if function for a range from 40-60 ?
Hi April

One way
=COUNTIF(A:A,"39")-COUNTIF(A:A,"60")

--
Regards

Roger Govier


"April" <April @discussions.microsoft.com wrote in message
...
I need to find the number of times in which a value is reported between
the
range of 40-60. I need the formula for this type of calculation


Reply With QuoteReply With Quote