ok this works

=COUNT(IF(H1:H2000="Max",IF(U1:U20000,U1:U2000,"" )))

is therre a way i can get it to look at all of column H and U?

everytime i take out the numbers behind the letters i get an error




"SteveG" wrote:


You could use COUNT and IF together as an array formula.

So say in H is where Max is and C is the month you want to look for and
count if U has a value in it.

=COUNT(IF(C1:C200="January",IF(H1:H200="Max",IF(U1 :U2000,U1:U200,""))))

Commit with Ctrl-Shift-Enter instead of just enter. This will create
the curly brackets around the formula like.

{=COUNT(IF(C1:C200="January",IF(H1:H200="Max",IF(U 1:U2000,U1:U200,""))))}

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=502645