M Mallycat Jul 17, 2006 #2 Because you are not using the formula correctly. This function only has 2 arguments, the first is the range, and the second is the criteria Hence this will count all the 1's in the range =countif(j2:j20,"1") Matt
Because you are not using the formula correctly. This function only has 2 arguments, the first is the range, and the second is the criteria Hence this will count all the 1's in the range =countif(j2:j20,"1") Matt
G Guest Jul 17, 2006 #3 ingeman said: why won't this formula work? =countif(j2:j20,"1",f2:f20<"40") Click to expand... 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<>"")) ---
ingeman said: why won't this formula work? =countif(j2:j20,"1",f2:f20<"40") Click to expand... 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<>"")) ---
