Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Counting Cells If several criteria are true (https://www.askmehelpdesk.com/showthread.php?t=28415)

  • Jun 26, 2006, 10:56 PM
    Amyunimus
    Counting Cells If several criteria are true
    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!
  • Jun 27, 2006, 01:35 AM
    colbtech
    =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

    • All times are GMT -7. The time now is 01:46 AM.