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

¦r¦ê¥[Á`¨D¸Ñ

¦r¦ê¥[Á`¨D¸Ñ

¦pªþ¥ó, ¨D¸Ñ

N1:¨D¥[Á`B2:L2Àx¦s®æ¤º/¥ªÃ䪺­È
O1:¨D¥[Á`B2:L2Àx¦s®æ¤º/¥kÃ䪺­È
P1:¨D¥[Á`B2:L2Àx¦s®æ¤º/¥ªÃ䪺­È &/& ¥[Á`B2:L2Àx¦s®æ¤º/¥kÃ䪺­È

¦r¦ê¥[Á`.rar (7.08 KB)

N1 =SUMPRODUCT(--(0&TRIM(LEFT(SUBSTITUTE(B2:L2,"/",REPT(" ",10)),10))))
O1 =SUMPRODUCT(--(0&TRIM(RIGHT(SUBSTITUTE(B2:L2,"/",REPT(" ",10)),10))))
P2 =N2&"/"&O2
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¢Ü¢°¡G=SUMPRODUCT(INT(SUBSTITUTE(0&B2:L2,"/",".")))
¢Ý¢°¡G=SUMPRODUCT(--(0&MID(B2:L2,FIND("/",B2:L2&"/")+1,15)))

©Î¡D¢Ü¢°¡G
=SUMPRODUCT(--MID(SUBSTITUTE($B2:$L2&".0/0","/",REPT(" ",20)),COLUMN(A$1)*20-19,19))¡@¥k©Ô

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD