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

½Ð°Ý¡Gsumif ¨ç¼Æ»yªk°ÝÃD

½Ð°Ý¡Gsumif ¨ç¼Æ»yªk°ÝÃD

Dear all,

§Ú¥Îsumif ¥h§ì¨úAÄæ¦ì(¦~¤ë)©Ò¹ïÀ³¤§¥[Á`¼Æ¾Ú
©ó6¤ë¥÷¤§«á¤§¸ê®Æ¨Ã¥¼µo¥Í(¬G¸ê®Æ®w¤¤µL¥ô¦ó¼Æ¾Ú)

§Ú§Æ±æ¯à¦bB7~B13Äæ¦ì¤¤Åã¥Ü¬OªÅ¥Õªº
¤½¦¡À³¸Ó¦p¦ó­×§ï
B2=SUMIF(©ú²Ó!$A$2:$A$1000000,A2,©ú²Ó!$L$2:$L$1000000)

Just do it.

IF(SUMIF(©ú²Ó!$A$2A$1000000,A2,©ú²Ó!$L$2L$1000000)=0,"",SUMIF(©ú²Ó!$A$2A$1000000,A2,©ú²Ó!$L$2L$1000000))
ù

TOP

±Æ°£0, ­n°µ¨â¦¸¹Bºâ, ®Ä²v¸û®t,
¤£Åã¥Ü0, ¥i¥Î¥H¤U¤èªk:
1) ¤u§@ªí¿ï¶µ, ¿ï[¤£Åã¥Ü¹s­È]
2) Àx¦s®æ®æ¦¡: [=0]#;G/³q¥Î®æ¦¡

TOP

¦^´_ 2# rouber590324
Test ¦¨¥\¡A§Úª¾¹D¤é«á¦p¦ó¹B¥Î¤F¡A·P®¦¡I
Just do it.

TOP

¦^´_ 3# ­ã´£³¡ªL
Dear ­ã´£³¡ªL,
·PÁ±zªº¦^ÂСA§Ú§Ñ¤F¥t¤@»Ý¨D¡A´N¬O¤]§Æ±æ¦bºâ"2019¥­§¡¼Æ¶q"¥i¥H¤£­n­pºâ¨ì¦³0­ÈªºÄæ¦ì
©Ò¥H¬O§Æ±æ·í¸ê®Æ®wµL¸Ó¤é´Á®É´Nµ¥©óªÅ¥Õ¡A¤£­n¦³0­È
·PÁ±z¡I ^_^
Just do it.

TOP

¦^´_ 5# jsc0518


¥­§¡¼Æ¶q¦b­þÄæ¦ì???
¤W¶ÇÀɮ׬ݬÝ???

TOP

¦^´_ 6# ­ã´£³¡ªL

Dear ­ã´£³¡ªL,

Àɮצpªþ¥ó
TSET.rar (44.4 KB)

Thanks¡I
Just do it.

TOP

¦^´_ 7# jsc0518


B2:
=IF(COUNTIF(©ú²Ó!A:A,A2),SUMIF(©ú²Ó!A:A,A2,©ú²Ó!L:L),"")

C2:
=IF(B2="","",B2/COUNTIF(©ú²Ó!A:A,A2))

TOP

¦^´_ 8# ­ã´£³¡ªL

·PÁ­㴣³¡ªL¦^ÂÐ
¤½¦¡TEST OK
Just do it.

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD