Thread: Another COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jon
 
Posts: n/a
Default 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.