Excel Hopeful
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 100
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
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