Thread: How do I use CountIf formula to count a within a range of numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
swatsp0p[_14_] swatsp0p[_14_] is offline
external usenet poster
  
Posts: 1
Default How do I use CountIf formula to count a within a range of numbers

Use two countif functions as such:

=COUNTIF(A1:A50,"<=50")-COUNTIF(A1:A50,"<41") returns the count of
items between 41-50 (both inclusive).

adjust the range as needed and substitute values to meet your needs.

of course, =COUNTIF(A1:A50,"<30") is all you need for your first
criteria.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=385614

Reply With QuoteReply With Quote