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

[µo°Ý] ¦p¦ó¨Ì·Ó¨â­Ó¬Û¦P±ø¥ó¡A±N¸ê®Æ¶×¤J«ü©w¦ì¸m

¦^´_ 9# p212
¦^´_ 10# pupai
¦^´_ 11# scjiao

=SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*¤À¼Æ)
p212¤jªº¤½¦¡¼Ð·Ç¥¿½TµL»~(«ÜÆg)

¼W¥[¯S®í±¡ªp³B²z¤è¦¡:
­Y¥H«á³B²z¸ê®Æ¤º®e¤ñ¸ûÂø¶Ã(¦³¤å¼Æ¦r²V¥Î)®É¡A¨Ò¦p ¤u§@ªíD2(¤ý¤Gªº°ê¤å¤À¼Æ)¶ñ¤J "¯Ê¦Ò" ®É
¥i¥H§ï¬°¤U¦¡³B²z¡C(SUMPRODUCTªº¯S©Ê¡A·í°Ñ¼Æ¬°½d³ò®É·|¦Û°Ê±NªÅ®æ¤Î«D¼Æ­È®æÂର0)
=SUMPRODUCT((Id=$A2)*(¤é´Á=$B2)*(¬ì¥Ø=C$1)*1,¤À¼Æ)

¤£ª¾§A¬Ý¥X®t²§¤F¶Ü?
¦¡¤¤ *1 ±N (§PÂ_¦¡) Âର0/1¡A­Y (§PÂ_¦¡) ¶W¹L1²Õ®É¥i¥H¤£¥Î¡A(§PÂ_¦¡1)*(§PÂ_¦¡2)*... ·|Âର0/1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# ML089


    ÁÂÁª©¥Dªº«ü¾É
    ·P®¦

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD