Is it possible to have multiple criteria for a countif function? Thanks.
B Bob Phillips Aug 11, 2005 #2 Not COUNTIF, but SUMPRODCT will =SUMPRODUCT(--(rng1="value1"),--(rng2=num2)) rng1 and rng2 must be the same size, and cannot be complete columns. -- HTH RP (remove nothere from the email address if mailing direct)
Not COUNTIF, but SUMPRODCT will =SUMPRODUCT(--(rng1="value1"),--(rng2=num2)) rng1 and rng2 must be the same size, and cannot be complete columns. -- HTH RP (remove nothere from the email address if mailing direct)
