[µo°Ý] excel ¤½¦¡ sumif

john2006168

¦U¦ì¤j¤j,½Ð°Ý¶À¦â¦ì¸m¬O§_¥i¥H¥Î¤½¦¡ªí¹F?

john2006168

¦^´_ 1# john2006168

Revised ¸ê®Æ.

mistery

¬Ý¤£À´§Aªºªí®æ·Q­nªí¹F?

john2006168

¦^´_ 3# mistery


    ­n¦³±ø¥ó¥[Á`

­ã´£³¡ªL

H11:
=LOOKUP(,0/FREQUENCY(1,1-COUNTIF(H$10:H10,B$3:B$8)),$B$3:B$8)&""

B11/°}¦C¤½¦¡(¤TÁä):
=SUM(MMULT(--TEXT(MID(SUBSTITUTE(SUBSTITUTE(IF($D$3:$D$8=C11,$C$3:$C$8,$D$3:$D$8),C11,),"+",REPT(" ",98)),{1,99},98),"0;;0;!0"),{1;1})*($B$3:$B$8=$H11))

¤½¦¡¶K¦ÜD11//¤U©Ô

john2006168

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


   

¤U¸ü (53.82 KB)

2019-8-8 16:11

¤£ª¾¹D¬°¤°»ò¶Ã½X?

­ã´£³¡ªL

¦^´_ 6# john2006168

¬ÝÀÉ®×:
TEST0708-01.rar (6.62 KB)

¤U¸ü¦¸¼Æ: 11

2019-8-8 16:50

excelÄæ¦ì¨º»ò¦h, ¦ó¥²§Ë¦¨¹³¤å¦rÀÉ???

john2006168

¤U¸ü (75.75 KB)

2019-8-9 12:22

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


    ¤£ª¾¹D¤°»ò­ì¦],¥´¶}´N¬O³o¼Ë.:'(

zz5151353

[i=s] ¥»©«³Ì«á¥Ñ zz5151353 ©ó 2019-12-31 11:00 ½s¿è [/i]

½Ð§â¤­¼Óª©¥D¤½¦¡­×§ï¬õ¦â¦a¤è´N¥i¥H¥¿±`Åã¥Ü¤F

   ! §ïÅܬ° \

=SUM(MMULT(--TEXT(MID(SUBSTITUTE(SUBSTITUTE(IF($D$3:$D$8=C11,$C$3:$C$8,$D$3:$D$8),C11,),"+",REPT(" ",98)),{1,99},98),"0;;0;[color=Red]\[/color]0"),{1;1})*($B$3:$B$8=$H11))