Posted to microsoft.public.excel.worksheet.functions

Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline

external usenet poster

Posts: 1,071

CountIf & multiple criteria

Excel XP
The formula =CountIf(A1:A50,"<80") counts the cells that have a value less
than 80. How would I modify this formula to change the criteria to less
than 80 AND more than 50? Thanks for your time. Otto

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
COUNTIF multiple criteria	SJC	Excel Worksheet Functions	3	November 6th 08 06:12 PM
Countif with multiple criteria	Paige	Excel Discussion (Misc queries)	7	March 12th 08 07:31 PM
Nesting COUNTIF for multiple criteria in multiple columns	NeedExcelHelp07	Excel Worksheet Functions	1	December 12th 07 05:47 PM
Help please - Countif with multiple criteria	Prickle	Excel Worksheet Functions	3	March 5th 06 09:52 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 05:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us