"ingeman" wrote:
why won't this formula work? =countif(j2:j20,"1",f2:f20<"40")

Guessing that the formula above represents what you want to do ..
Assuming cols J and F actually contain real numbers
with the possibility of some empty cells within col F,
try instead:
=SUMPRODUCT((J2:J20=1)*(F2:F20<40)*(F2:F20<""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---