Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How do I use CountIf formula to count a within a range of numbers


I'd like to know how to use the countIF formula better. I have a poo
of 50 returns that I'm trying to group within a couple of ranges. 3
and below, 31 to 40, 41 to 50, 51 to 60, ect... I am using the pool o
50 returns as the range but am having trouble defining the criteria whe
it comes to looking for numbers that fall between a group, ex 41 to 50

--
petevan
-----------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...fo&userid=2503
View this thread: http://www.excelforum.com/showthread.php?threadid=38561

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Countif to Count Consecutive Relative Increases in Numbers SteveC Excel Discussion (Misc queries) 16 September 27th 06 04:55 PM
countif when range to count is in a different workbook KarenF Excel Discussion (Misc queries) 2 August 8th 06 04:56 PM
Count comma separated numbers, numbers in a range with dash, not t Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM
How do I use CountIf formula to count a within a range of numbers swatsp0p[_14_] Excel Programming 0 July 8th 05 04:35 PM
How do I create formula to count numbers in a range of cells? EmilyJ Excel Worksheet Functions 1 December 8th 04 05:24 AM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"