比如1级无气味后第一个单元格为D3,思路是用counta判断此行不为空单元格数量用气味等级=counta(D4:K4)+counta(D5:K5)*2+counta(D6:K6)*3+counta(D7:K7)*4