Posted to microsoft.public.excel.worksheet.functions

Jon

Posts: n/a

Another COUNTIF

I have a range F52:H73, I am trying to count the numbers0,and <125.

I came up with
=COUNT(IF(F52:H73<0<125,F52:H73))

Range looks like
Game 1 Game 2 Game 3
120 146 95
133 147 50
0 0 0
166 146 135
0 0 0
121 159 168
123 170 125
0 0 0
121 121 121
155 145 140
140 167 137

Any help is 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
Countif, then multiply??	Gee-off	Excel Worksheet Functions	4	December 7th 05 08:55 PM
COUNTIF or not to COUNTIF on a range in another sheet	Ellie	Excel Worksheet Functions	4	September 15th 05 10:06 PM
COUNTIF help	Ant	Excel Worksheet Functions	4	August 10th 05 09:02 PM
Combining IF and COUNTIF based on two columns	maxtrixx	Excel Discussion (Misc queries)	5	March 31st 05 06:21 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM

All times are GMT +1. The time now is 12:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us