Posted to microsoft.public.excel.misc

Nigel

external usenet poster

Posts: 98

Count the number between age ranges

I have a spreadsheet (Replies) which contains ages in column C. I want to be
able to count all those who fall between certain bands/groups i.e. 25 - 34. I
have tried to use the following:
=COUNTIF(Replies!C5:C100,"=25")-COUNTIF(Replies!C5:C100,"<=34")
which I have obtained and modified from othert threads, but I don't get the
answers I expect.

Any help would be appreciated.

Thanks

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
Lookup one value and count in two ranges	Leanne at Work	Excel Discussion (Misc queries)	4	July 30th 08 12:33 PM
Count age ranges	James	Excel Worksheet Functions	8	November 9th 07 08:04 PM
How can I count the number of ranges in a worksheet consolidation	kuma-kami	Excel Worksheet Functions	0	March 7th 07 05:34 AM
count age ranges	Clash	Excel Discussion (Misc queries)	3	June 13th 06 03:05 PM
count if in two ranges	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	0	October 8th 05 04:47 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us