sparkytech
Board Regular
- Joined
- Mar 6, 2018
- Messages
- 96
- Office Version
- 365
- 2019
Ok. I'm racking my brain on this one. I need a formula to look at E5:E2000 for non-blank cells, and then count any cells in L5:L2000 that contain "N/A", "n/a", "TBD", "tbd" or are blank. Seems simple enough, but can't put this one together, hence the lack of code. Can someone guide me? Thanks!