i8urkeyboard
New Member
- Joined
- Jul 5, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I am trying to write a formula where it only counts cells with text value and return "1" and ignores the blank cells. all the cells in this column have formulas.
I have tried using the SUBTOTAL formula with ISTEXT such as this: =IF(ISTEXT(C6),(SUBTOTAL(103,C6)),"0") But this is not working out for me.
Any help will be appreciated.
Thanks
I have tried using the SUBTOTAL formula with ISTEXT such as this: =IF(ISTEXT(C6),(SUBTOTAL(103,C6)),"0") But this is not working out for me.
Any help will be appreciated.
Thanks