fastballfreddy
Board Regular
- Joined
- Jan 13, 2015
- Messages
- 57
- Office Version
- 2016
- Platform
- Windows
Needing a formula to count non blanks in 1st column and blanks in the 2nd column. So the example it would count 2. the text is giving me issues trying to do a COUNTIFS formula and using COUNTA formula. I've searched and tested but nothing is working for me. appreciate any help in advance.
<tbody>
</tbody>
count non blanks | count blanks |
x | |
text2 | |
text3 | x |
text5 |
<tbody>
</tbody>