ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[½Ð°Ý] ­pºâ¥­§¡®É¶¡

±N²Î­p²¾¦ÜH~MÄæ
Xl0000365.rar (4.27 KB)

I3/¤½¦¡: ¥k©Ô¤U©Ô
=SUMIF($A:$A,$H3,$F:$F)*SUMIF($A:$A,$H3,B:B)/SUM(SUMIF($A:$A,$H3,OFFSET($A:$A,,{1,2,3,4})))

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD