Judy Felfe

Posts: n/a

counting occurrences in a range

How do I count the number of occurrences of values between 25,000 and 50,000
within a range of numbers? I have tried

countif(g2:g1695,AND("=25000","<50000"))

but it gives a result of 0. Thanks in advance.

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
Counting within a filtered range	Jeff	Excel Worksheet Functions	2	June 13th 05 03:33 AM
Counting empty cells within a range of cells	Rosehill - ExcelForums.com	New Users to Excel	2	May 2nd 05 08:53 AM
adding occurrences for date range	Mike	Excel Discussion (Misc queries)	0	April 11th 05 05:24 PM
Counting empty cells within a range of cells	Rosehill - ExcelForums.com	New Users to Excel	0	April 7th 05 12:47 AM
Counting occurrences of multiple conditions	Jvanderv1	Excel Discussion (Misc queries)	2	April 6th 05 01:07 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us