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

[µo°Ý] ¦Û°Ê¹ïÀ³¦C¼Æªº¤½¦¡°Ñ·Ó(¤p°ÝÃD½Ð±Ð)

¨Ò¦p
DG15 =SUMPRODUCT(--($DD$2:$DD$350=DG14))
DH15 =SUMPRODUCT(--($DD$2:$DD$350=DH14))
DI15 =SUMPRODUCT(--($DD$2:$DD$350=DI14))
DJ15 =SUMPRODUCT(--($DD$2:$DD$350=DJ14))

DG16 =SUMPRODUCT(--($DD$2:$DD$350=DG14))/COUNTA($DD$2:$DD$350)
DH16 =SUMPRODUCT(--($DD$2:$DD$350=DH14))/COUNTA($DD$2:$DD$350)
DI16 =SUMPRODUCT(--($DD$2:$DD$350=DI14))/COUNTA($DD$2:$DD$350)
DJ16 =SUMPRODUCT(--($DD$2:$DD$350=DJ14))/COUNTA($DD$2:$DD$350)


¤u¨ã¦C - ¤½¦¡ - ©w¸q¦WºÙ

¦WºÙ:DD
°Ñ·Ó©ó:=OFFSET($DD$2,,,COUNTA($DD:$DD)-1)

¤½¦¡­×§ï¬°()
DG15 =SUMPRODUCT(--(DD=DG14))
DH15 =SUMPRODUCT(--(DD=DH14))
DI15 =SUMPRODUCT(--(DD=DI14))
DJ15 =SUMPRODUCT(--(DD=DJ14))

DG16 =SUMPRODUCT(--(DD=DG14))/COUNTA(DD)
DH16 =SUMPRODUCT(--(DD=DH14))/COUNTA(DD)
DI16 =SUMPRODUCT(--(DD=DI14))/COUNTA(DD)
DJ16 =SUMPRODUCT(--(DD=DJ14))/COUNTA(DD)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

·í¸ê®Æ¦h­pºâ¦h®É¡A±Ä¥Î¦WºÙ³]©w °ÊºA¸ê®Æ½d³ò¡A¥i¥H¸`¬Ù¤£¥²­nªº­pºâ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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