Posted to microsoft.public.excel.worksheet.functions

SJC

external usenet poster

Posts: 22

COUNTIF multiple criteria

I am having trouble with a formula that will count if two criteria are true,
so that I want it to count if the cell is between 100 and 500. Right now,
here is the formula I am using, but it does not work.

=COUNTIF(F309,"100")-COUNTIF(F309,"<500")

Any help would be greatly 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
Nesting COUNTIF for multiple criteria in multiple columns	NeedExcelHelp07	Excel Worksheet Functions	1	December 12th 07 05:47 PM
Countif Multiple Criteria	jackie	Excel Worksheet Functions	3	June 14th 07 04:47 PM
countif multiple criteria	Iamwhoiam	Excel Worksheet Functions	1	June 27th 06 08:26 PM
Countif w/ Multiple Criteria	Patrick_KC	Excel Worksheet Functions	2	August 9th 05 09:25 PM
Countif with multiple criteria and multiple worksheets	JJ	Excel Worksheet Functions	1	December 28th 04 06:37 PM

All times are GMT +1. The time now is 11:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us