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

[µo°Ý] SUMIF, COUNT ¤½¦¡°ÝÃD

[µo°Ý] SUMIF, COUNT ¤½¦¡°ÝÃD

¥»©«³Ì«á¥Ñ t8899 ©ó 2012-12-26 20:52 ½s¿è

·Q¥[Á`AÄæ±qA1¥[¨ì¦³"13:15"ªº«e¤@®æ¬°¤î??¤½¦¡¦p¦ó¼g??
¥t¥~
¤@¼ËºâAÄæ A1 ¨ì"13:15" ¤§¶¡«DªÅ¥ÕªºÀx¦s®æ¼Æ¥Ø

P.S.¹ê»Ú©Ò¨D¬°¹ïÀ³ªºBÄæ

P.S.
13:15 ¬°¥X²{¦bAÄ檺®É¶¡
¹ê»Ú©Ò¨D¬°¹ïÀ³ªºBÄæ

TOP

¦^´_ 2# t8899

¥[Á`
=SUMIF(A:A,"<13:15",B:B)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  t8899

¥[Á`
=SUMIF(A:A,"
Hsieh µoªí©ó 2012-12-26 21:40

¦pªþ¹Ï¡Aµª®×¬°b1:b5 ªº¦X­p10

TOP

©êºp¡AAÄæ³£¬O®É¶¡¸ê®Æ

TOP

SORRY ,AÄæ¥þ´«¬°®É¶¡´Nok  ¤F,¨S°ÝÃD¤F

TOP

¯uÁV¿|¡A°ÝÃD¯u¦h
§Ú·Q¦b¨D±oªºBÄæ¦b³]¤@­Ó>0ªº±ø¥ó

TOP

¦^´_ 4# t8899
·q½Ð°Ñ¦Ò
1. ¥[Á`A1 ¨ì"13:15:30"ªº«e¤@®æµ²ªG_C1Àx¦s®æ¤ºªº¤½¦¡¬°
=SUM(OFFSET(A1,,,MATCH(VALUE("13:15:30"),A:A,0)-1))
2. A1 ¨ì"13:15:30" ¤§¶¡«DªÅ¥ÕªºÀx¦s®æ¼Æ¥Ø__C2Àx¦s®æ¤ºªº¤½¦¡¬°
=COUNT(OFFSET(A1,,,MATCH(VALUE("13:15:30"),A:A,0)-1))

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2012-12-27 09:46 ½s¿è
1. ¥[Á`A1 ¨ì"13:15:30"ªº«e¤@®æµ²ªG_C1Àx¦s®æ¤ºªº¤½¦¡¬°
=SUM(OFFSET(A1,,,MATC ...
p212 µoªí©ó 2012-12-27 09:29


¨S¦³"BÄæ¦b³]¤@­Ó>0ªº±ø¥ó" ??

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD