Following up on my question, I am looking for help to use Excel 2019
- to count a number of cells that have content on one side (<>"") and after TRIM() should still contain content.
- This formula is to be extended by a condition (Boolean value in column A => TRUE).
Thank you for your assistance.
The result can only be
=0). The multiplication
1 is necessary so that the result
FALSE is also correctly recognized as
1 in the matrix.
Formula used in cell B13.
Try the formulas and report back if it works for you.