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

[µo°Ý] ½Ð°Ý¦p¦ó­pºâ³sÄò¥X²{¦¸¼Æ?

D2=SUM(-TEXT(QUARTILE(SIGN(E2:Z2)*(COLUMN(E2:Z2)-4),{4,0}),{"-0;!0","!0;0"}))
°}¦C¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 20# jak


    ªÅ®æ¥i¥Î
=LOOKUP(9^9, E2:Z2,FREQUENCY(COLUMN(E:Z),((SIGN(E2:Z2)<>SIGN(F2:AA2)))*COLUMN(E:Z)))*SIGN(LOOKUP(9^9,E2:Z2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD