USING COUNTIF WITH MULTIPLE CRITERIA
Posted on 2002-06-03
I want to be able to do a COUNTIF on 2 columns at the same time. So in Column K, I have either a 1, 2 or 3. In Column L, I have either a 1, 2 or 3. I want it to count only those rows that have both a "1" in Columns K AND L. Here's what I've tried, but these don't work.
=COUNTIF(K2:K34,"1")*AND(L2:L34,"1") I get #VALUE
=COUNTIF(K2:K34,"1")*AND(COUNTIF(L2:L34,"1")) get error message
I've tried using the AND function, but am not sure how to use it with COUNTIF function, if I even can (?????).