如题所述
L3=SUMPRODUCT($B$2:$J$2*B3:J3)
L15=SUMPRODUCT(--RIGHT($B$14:$J$14,2*LEN($B$14:$J$14)-LENB($B$14:$J$14))*B15:J15)
å ¬å¼åä¸å¤å¶
有单价啊 第一例上面那一排都有
带行号列标,重新截图上来。