PDA

View Full Version : Excel (IF Condition)


mabdulmatheen
Jun 26, 2012, 03:59 AM
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.