Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40"))
I ingeman Jul 17, 2006 #1 Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40"))
B Biff Jul 17, 2006 #2 ingeman said: Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40")) Click to expand... Try this: =SUMPRODUCT(--(K2:K20=1),--(J2:J20<40)) Biff
ingeman said: Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40")) Click to expand... Try this: =SUMPRODUCT(--(K2:K20=1),--(J2:J20<40)) Biff
