|
各位大大,我怎麼樣才可以把公式里所有的$N:$N,更改為$O:$O,還有J:J改為G:G
我現在情況一個一個KEY,請各位大大幫幫忙
=SUMIF('03月计划(外注物動)'!$D:$D,"YPSU-J014A",'03月计划(外注物動)'!$O:$O)*SUMIF($D:$D,"YPSU-J014A",G:G) | =SUMIF('03月计划(外注物動)'!$D:$D,"YPSU-J017A",'03月计划(外注物動)'!$O:$O)*SUMIF($D:$D,"YPSU-J017A",G:G) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J702A(F)",'03月计划(外注物動)'!$O:$O)*SUMIF($D:$D,"PSPU-J702A(F)",G:G) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J704A(F)",'03月计划(外注物動)'!$O:$O)*SUMIF($D:$D,"PSPU-J704A(F)",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J705A(B)",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPU-J705A(B)",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J806A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPU-J806A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J808A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPU-J808A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J902A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPU-J902A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPU-J904A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPU-J904A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPF-L911A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPF-L911A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPI-L912A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPI-L912A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPI-L913A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPI-L913A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPF-L915A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPF-L915A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPI-L916A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPI-L916A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPF-L011A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPF-L011A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPI-L013A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPI-L013A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPL-L014A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPL-L014A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPF-L021A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPF-L021A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPI-L023A",'03月计划(外注物動)'!$N:$N)*SUMIF($D:$D,"PSPI-L023A",J:J) | =SUMIF('03月计划(外注物動)'!$D:$D,"PSPL-L024A",'03月计划(外注物動)'!$O:$O)*SUMIF($D:$D,"PSPL-L024A",G:G) |
|
|