Easy head scratcher...countif one column if another column does NOT contain a certain word

[Excel Hopeful]

Column
A B
Alex Complete
Alex Wip
Alex Complete
Jenny Wip
Jenny Wip
Jenny Complete
Alex Open


Looking for a cell to count number of "Alex's" in column if column B is NOT Complete. It this situation, it should return 2.

Thank you

 

[Aladin Akyurek]

Column
A B
Alex Complete
Alex Wip
Alex Complete
Jenny Wip
Jenny Wip
Jenny Complete
Alex Open


Looking for a cell to count number of "Alex's" in column if column B is NOT Complete. It this situation, it should return 2.

Thank you

One of...

=COUNTIFS($A$2:$A$8,"Alex",$B$2:$B$8,"<>Complete")

=SUMPRODUCT(--($A$2:$A$8="Alex"),1-($B$2:$B$8="Complete"))

 

[Marcelo Branco]

Excel 2007 or higher
=COUNTIFS(A:A,"Alex",B:B,"<>Complete")

Excel 2003
=SUMPRODUCT(--(A2:A100="Alex"),--(B2:B100<>"Complete"))

M.

 

[Excel Hopeful]

One of...

=COUNTIFS($A$2:$A$8,"Alex",$B$2:$B$8,"<>Complete")

=SUMPRODUCT(--($A$2:$A$8="Alex"),1-($B$2:$B$8="Complete"))

Thank You Aladin, works perfect....