jsky

Posts: n/a

Chip, I figured it out. Thank you again.

"jsky" wrote:

Thanks Chip.
really use minus sign between them? Does that serve as an "AND"?

"Chip Pearson" wrote:

Use two COUNTIF functions. E.g.,

=COUNTIF(A1:A10,"<100")-COUNTIF(A1:A10,"<90")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"jsky" wrote in message
...
how can I use the COUNTIF formula to count only those numbers
that fit
between a range like greater than 90 but less than 100.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Count occurances in range of cells	Ed Gregory	Excel Worksheet Functions	1	September 7th 05 04:12 PM
countif argument for 3 occurences of which 1 refers to a range	Andy	Excel Discussion (Misc queries)	2	September 7th 05 03:19 PM
Formula to count the cells in a range that have a fill color.	Slainteva	Excel Discussion (Misc queries)	2	January 19th 05 08:25 PM
Formula to count the cells in a range that have a fill color.	Molly F	Excel Discussion (Misc queries)	2	January 19th 05 06:15 PM
variable range countif	JK	Excel Worksheet Functions	3	November 3rd 04 07:50 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us