excel某单元格的内容作为指定区域该如何引用

2025-04-13 02:15:57
推荐回答(1个)
回答1:

如图例:

A8=SUMPRODUCT(LEN(INDIRECT($C$7&ROW()):INDIRECT($D$7&ROW()))-LEN(SUBSTITUTE(INDIRECT($C$7&ROW()):INDIRECT($D$7&ROW()),A$7,"")))

右拉下拉