PC Review

Reply

Rate Thread

Countif number between x and y

Bill

Guest

Posts: n/a

14th Apr 2010

Have a column of figures and want to countif the value in cell falls between
x or y
That is countif(e:e, >5 or <10)

Reply With Quote

Reply

« Look for names when cursor is there.. | Fix the size of form controls in a worksheet »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif until a number occurs four times in a row then return that number	Ephraim	Microsoft Excel Worksheet Functions	3	4th Sep 2010 08:03 PM
COUNTIF SPECIAL NUMBER	Aron	Microsoft Excel Misc	2	29th May 2008 09:14 PM
countif formula to find the occurances of a number that is greater than one number but less than another	steveo	Microsoft Excel Misc	3	8th Jul 2006 02:04 AM
Countif to always get a positive number	=?Utf-8?B?T3JsYW5kb0ZyZWVtYW4=?=	Microsoft Excel Misc	2	1st Jul 2006 03:27 PM
countif maximum number	=?Utf-8?B?QnJpYW4=?=	Microsoft Excel Worksheet Functions	1	18th Oct 2004 04:07 PM

Features

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

All times are GMT +1. The time now is 12:01 PM.