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!

=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