COUNT BETWEEN A RANGE AND

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1,388

COUNT BETWEEN A RANGE AND

HI

I WOULD LIKE TO COUNT VALUES BETWEEN A RANGE. THE FORMULA I HAVE TRIED TO
USE IS: COUNTIF(D:D,"30000AND<75000") TO GET THE NUMBER OF VALUES BETWEEN 30
AND 75, HOWEVER, THIS DOES NOT WORK. CAN SOMEONE HELP?

ALSO, ON TOP OF THIS I WOULD LIKE TO COUNT A STATEMENT IN ANOTHER COLUMN
WHICH SAYS YES OR NO. SO THAT FROM THE VALUES BETWEEN 30 AND 75 I WOULD LIKE
TO KNOW WHICH ONES ARE ALSO YES AND NO. ANYONE WHO CAN HELP ME MUCH
APPRECIATED

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 within a Range Q	Sean	Excel Worksheet Functions	10	February 20th 08 07:47 PM
Multiple Criteria, Count If, Sum Product to get count across range	Jonathan	Excel Worksheet Functions	5	January 9th 08 11:32 PM
Using a count in a range name	Steve	Excel Discussion (Misc queries)	1	September 18th 07 05:20 PM
How to count dates within a certain range in a column with mutiple date range entries	Krisjhn	Excel Worksheet Functions	2	September 1st 05 01:59 PM
Count cells in one range based on parameters in another range	dave roth	Excel Worksheet Functions	2	March 29th 05 05:33 PM

All times are GMT +1. The time now is 11:09 AM.

Menu

About Us