CURRENT"or"<>EXTENDED"or"<>BLANK")+COUNTIF(B1:B4,"EXPIRED") End goal being a total for contracts not current. In this case 0. If any further clarification is needed please let me know. Thank you. .">
Most valuable professional
  • Hot Topics

Excel COUNTIF or SUMPRODUCT if adjecent CELL is not STRING

Hi, Im trying to display the number of cells in a column containing "x" if adjecent column is not equal to "y" or "z" or "blank". Example; 1 (VALUE) 2 (VALUE) 3 (VALUE) 4 (VALUE) I know this isnt right but its the best way i can explain it. =COUNTIF(A1:A4,"EXPIRED",B1:B4,"<>CURRENT"or"<>EXTENDED"or"<>BLANK")+COUNTIF(B1:B4,"EXPIRED") End goal being a total for contracts not current. In this case 0. If any further clarification is needed please let me know. Thank you.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of March 25, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel