Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Distance Learning (https://www.askmehelpdesk.com/forumdisplay.php?f=97)
-   -   Excel (IF Condition) (https://www.askmehelpdesk.com/showthread.php?t=675356)

  • Jun 26, 2012, 03:59 AM
    mabdulmatheen
    Excel (IF Condition)
    If a column contains the Revisions like A0, A1, A2, A3 & B0, B1, B2, B3 & Z0, Z1, Z2, Z3and another column contains the Discipline Civil, Mechanical, Electrical, Instr.

    I need to count How many Z series for Civil discipline.

    =SUM(IF(A1:A24="Civil",IF(A1:A24="Z0",1,0),0)) it gives only Z0 count but I need Z0+Z1+Z2+Z3 counts.

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