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

Àx¦s®æ¼Æ¶q²Î­p

Àx¦s®æ¼Æ¶q²Î­p

½Ð±Ð«e½ú

A3:A100¤§¸ê®Æ¬°¬P´Á Mon, Tue.......
²Î­pÀx¦s®æ½d³ò¡GD3:D100, G3:G100, I3:I100

·íA3:A10Äæ¡×Mon ²Î­pD, G, IÄ榳¸ê®Æ¤§Àx¦s®æ¼Æ¶q
·íA3:A10Äæ¡×Tue ²Î­pD, G, IÄ榳¸ê®Æ¤§Àx¦s®æ¼Æ¶q
¥H¦¹Ãþ±À

½Ð°Ý¦p¦ó¨Ï¥Î¨ç¼Æ
ÁÂÁÂ
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# b9208
=SUMPRODUCT(($A$3:$A$100="Mon")*(($D$3:$D$100<>"")+($G$3:$G$100<>"")+($I$3:$I$100<>"")))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

ÁÂÁª©¥D«ü¾É
°ÝÃD¤w¸g¸Ñ¨M¤F
100 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD