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

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

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

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

TEST0708.zip (6.63 KB)

[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))

TOP

Â^¨ú.JPG
2019-8-9 12:22
¦^´_ 7# ­ã´£³¡ªL


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

TOP

¦^´_ 6# john2006168

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

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

TOP

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


   
Â^¨ú.JPG
2019-8-8 16:11


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

TOP

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©Ô

TOP

¦^´_ 3# mistery


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

TOP

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

TOP

¦^´_ 1# john2006168

Revised ¸ê®Æ.
Â^¨ú0708rev.JPG

TEST0708rev.zip (6.6 KB)

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD