如图例:
A8=SUMPRODUCT(LEN(INDIRECT($C$7&ROW()):INDIRECT($D$7&ROW()))-LEN(SUBSTITUTE(INDIRECT($C$7&ROW()):INDIRECT($D$7&ROW()),A$7,"")))
右拉下拉