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

­n¦X­pAÄ椤©Ò¦³ªºA¶}ÀY½s¸¹ªºBÄæ

­n¦X­pAÄ椤©Ò¦³ªºA¶}ÀY½s¸¹ªºBÄæ

¥»©«³Ì«á¥Ñ KOTOHO ©ó 2010-8-5 07:15 ½s¿è

½Ð°Ý¦U¦ì

­n¦X­pAÄ椤©Ò¦³ªºA¶}ÀY½s¸¹ªºBÄæ

½Ð°Ý¤½¦¡­n«ç»ò³]?

(EX: AÄæ½s¸¹:A01,A02,B01,B02,C01,D01.....)

ÁÂÁÂ

¦^´_ 10# Hsieh

¾Ç¨ì¤F,ÁÂÁÂ

TOP

=SUMPRODUCT((LEFT(A1:A100)="A")*(B1:B100))
Hsieh µoªí©ó 2010-8-8 22:32


¦bµL»Ý¥Î°}¦C¤½¦¡¤U¹F¦¨¡A³o­Ó¹ê¦b¤Ó§Q®`¤F¡A§®¥Î¡I
=SUMPRODUCT((LEFT(A1:A100)="A")*(B1:B100))

§¹¥þµ¥¦P¥H¤U°}¦C¤½¦¡¡C
=SUM((LEFT(A1:A100)="a")*(B1:B100))

TOP

=SUMPRODUCT((LEFT(A1:A100)="A")*(B1:B100))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ KOTOHO ©ó 2010-8-8 21:49 ½s¿è

ÁÂÁ¦^µª  

TOP

¸Ñ¨M¤F,ÁÂÁÂ!^^

½Ð°Ý¥[¤£¥[°}¦C²Å¸¹ªº®t§O¦b©ó?
KOTOHO µoªí©ó 2010-8-8 21:42


¥Î¤W­±ªº¤½¦¡¬°¨Ò¡G
¥Î°}¦Cªº¸Ü, range ¤º©Ò¦³ cell ³£·|¶i¦æ¤@¦¸­pºâ¡C¤£¬O°}¦Cªº¸Ü¡A¥u·|­p²Ä¤@­Ó cell¡C

TOP

¥Î°}¦C¤½¦¡¡G
¿é¤J¥H¤U¤½¦¡¡A¦P®É«ö¤U ctrl + shift + enter
=SUM(IF(LEFT(A1:A100,1)="a",B1:B100))
ivanyung µoªí©ó 2010-8-8 21:28



¸Ñ¨M¤F,ÁÂÁÂ!^^

½Ð°Ý¥[¤£¥[°}¦C²Å¸¹ªº®t§O¦b©ó?

TOP

¥Î°}¦C¤½¦¡¡G
¿é¤J¥H¤U¤½¦¡¡A¦P®É«ö¤U ctrl + shift + enter
=SUM(IF(LEFT(A1:A100,1)="a",B1:B100))

TOP

¥»©«³Ì«á¥Ñ KOTOHO ©ó 2010-8-8 21:00 ½s¿è

ÁÂÁ¦U¦ì,§Ú­«·s»¡©ú§Úªº·N«ä:

§ÚªºBÄæ¬O¼Æ¶q,AÄæ¬O½s¸¹

§Ú·Q­nºâ¥XAÄ椤,½s¸¹EX:A02,A100,A025,A300....©Ò¦³A¶}ÀYªº¡uBÄæÁ`¼Æ¶q¡v

ÁÂÁ¦U¦ì

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-8-5 08:54 ½s¿è

¦^´_ 1# KOTOHO


  1.'=COUNTIF(A:A,"A*")

  2.¦Û°Ê¿z¿ï\¦Û­q\A*'=SUBTOTAL(3,A2:A9)

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD