excel表格吧 关注:13,461贴子:27,308
  • 0回复贴,共1

求以下两个计算的简便方法

只看楼主收藏回复

1、=G92*H92+I92*J92+K92*L92+M92*N92+S92*T92+U92*V92+W92*X92+Y92*Z92+O92*P92+Q92*R92
2、=(H79-进货!$D$4)*G79+(J79-进货!$F$4)*I79+(L79-进货!$H$4)*K79+(N79-进货!$J$4)*M79+(P79-进货!$L$4)*O79+(R79-进货!$N$4)*Q79+(T79-进货!$P$4)*S79+(V79-进货!$R$4)*U79+(X79-进货!$T$4)*W79+(Z79-进货!$V$4)*Y79
求指点,谢谢


1楼2022-01-10 23:24回复