Count Lines in a Cell or Range of Cell
To count the number of lines in any cell with Wrap Text on, use
Keep in kind that the formula above WILL return 1 for an empty cell, due to +1. Overcome that problem by use of this function;
The +(LEN(A1)>1) will either return TRUE (1) or FALSE (0).
f more than a single cell, you can repeat the formula for each cell in the range and SUM the results (My preference). Or use a single cell and nest the formula above with a
|Count Between Date Ranges|
|Excel Count If With Multiple Criteria|
|Examples & Usage Of Excel CountIf Function|
|Examples & Usage Of Excel Counting Functions|
|Count Lines in a Cell|
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.