[FONT="]Hi,[/FONT]
[FONT="]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".[/FONT]
[FONT="]Example;[/FONT]
<tbody style="box-sizing: border-box; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>[FONT="]I know this isnt right but its the best way i can explain it.[/FONT]
[FONT="]=COUNTIF(A1:A4,"EXPIRED",B1:B4,"<>CURRENT"or"<>EXTENDED"or"<>BLANK")+COUNTIF(B1:B4,"EXPIRED")[/FONT]
[FONT="]End goal being a total for contracts not current. In this case 0.[/FONT]
[FONT="]If any further clarification is needed please let me know.[/FONT]
[FONT="]Thank you.[/FONT]
[FONT="]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".[/FONT]
[FONT="]Example;[/FONT]
A (CONTRACT) | B (RE-CONTRACT) | |
1 (VALUE) | CURRENT ("y") | BLANK |
2 (VALUE) | EXPIRED ("x") | CURRENT ("y") |
3 (VALUE) | CURRENT ("y") | BLANK |
4 (VALUE) | EXPIRED ("y") | EXTENDED ("z") |
<tbody style="box-sizing: border-box; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>
[FONT="]=COUNTIF(A1:A4,"EXPIRED",B1:B4,"<>CURRENT"or"<>EXTENDED"or"<>BLANK")+COUNTIF(B1:B4,"EXPIRED")[/FONT]
[FONT="]End goal being a total for contracts not current. In this case 0.[/FONT]
[FONT="]If any further clarification is needed please let me know.[/FONT]
[FONT="]Thank you.[/FONT]