我希望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),""))+1And if you just want the total of the whole range, use:
=SUMPRODUCT(LEN(B2:D2)-LEN(SUBSTITUTE(B2:D2,CHAR(10),"")))+COUNTA(B2:D2)更多推荐
发布评论