Counting Cells If several criteria are true

Amyunimus · #1 Jun 26, 2006, 09:56 PM

Another question.

I'd like to count the number of cells in column C that have "incorrect" in them, if the corresponding cells in column A have "people" in it, and column B has "intact" in it.

So if A = people and B = intact, count all C that = incorrect.

Thanks!

colbtech · Jun 27, 2006, 12:35 AM

=IF(A1="people",IF(B1="intact",IF(J1="incorrect",1 ,0)))

This will put a 1 in the target cell IF all conditions are met.

Then select all the target cells and click on the Autosum icon



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!