Hi, I am trying to count cells with text that are adjacent that also contain text. I do not want it to count if the adjacent cell is blank.
Basically, every time a filled cell touches another filled cell I want to count that. Is this possible?
Example Data:
Column A: Column B: Column C: Column D:
Row 2: Week 1 Week 2 Week 3 Count
Row 3: Yes Yes 1
Row 4: Yes 0
Row 5: Yes Yes Yes 2
Thanks!
Bookmarks