我希望excel公式计算出包含多行文本范围的总行数？(I want the excel formula to get count of total line numbers which has mul

我希望excel公式计算出包含多行文本范围的总行数？(I want the excel formula to get count of total line numbers which has multi line text in range?)

我希望excel公式计算出包含多行文本范围的总行数？

硬编码Excel工作表示例的图像

I want the excel formula to get count of total line numbers which has multi line text in range?

image of hard coded excel sheet example

最满意答案

=LEN(B2)-LEN(SUBSTITUTE(B2,CHAR(10),""))+1

如果您只想要整个范围的总和，请使用：

=SUMPRODUCT(LEN(B2:D2)-LEN(SUBSTITUTE(B2:D2,CHAR(10),"")))+COUNTA(B2:D2) =LEN(B2)-LEN(SUBSTITUTE(B2,CHAR(10),""))+1

And if you just want the total of the whole range, use:

=SUMPRODUCT(LEN(B2:D2)-LEN(SUBSTITUTE(B2:D2,CHAR(10),"")))+COUNTA(B2:D2)