Posted to microsoft.public.excel.worksheet.functions

Jen

external usenet poster

Posts: 119

I need a fx for counting numbers between numbers (between 18 - 59

I am trying to have excel count numbers that fall between certain numbers.
I.e. all numbers in column B that range from 18-59 (that include the #18 and
# 59). I have tried the COUNTIF fx but can only do "=18" and "<=59" This
ends up counting all numbers above 18 and all numbers below 59. I tried
BETWEEN 18 AND 59 but I obvoiusly don't know the appropiate language. Thanks
in advance. Jen

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 Numbers	Buffalo	Excel Worksheet Functions	4	December 3rd 08 09:52 PM
counting numbers??	bouncebackability	Excel Worksheet Functions	7	January 22nd 08 09:14 PM
Counting two numbers	vijaydsk1970	Excel Worksheet Functions	3	April 3rd 07 06:27 PM
counting numbers	dmack	Excel Discussion (Misc queries)	6	January 24th 07 07:50 PM
Counting Numbers	Funkydan	Excel Discussion (Misc queries)	3	November 19th 06 10:13 AM

All times are GMT +1. The time now is 09:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us