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

¤À¶}¥[Á`

¤À¶}¥[Á`

¦U¦ì¦n¡G

A1        B1
a3001        1
a3002        2
a3003        3
a5001        4
a5002        5
a5003        6
½Ð°Ý¦p¦ó¦bC1±Na3001-a3003¥[Á`¡A¦bC2±Na5001-a5003¥[Á`¡H ÁÂÁ¡I

¥»©«³Ì«á¥Ñ victorl ©ó 2010-6-6 19:25 ½s¿è

¦^´_ 1# tinching


    C1=SUMIF(A1:A6,"a3*",B1:B6)
    C2=SUMIF(A1:A6,"a5*",B1:B6)

»¡©ú:
[criteria]"a3*"¥Ha3¶}ÀYªº±ø¥ó

TOP

=SUMPRODUCT((LEFT(A2:A7,2)="a3")*B2:B7)
学习

TOP

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

¥H¤W¨â¦ìªº¸Ñµª¡A³£¥i¥H¥Î¡AÁÂÁ¡I
¦ý¦A·Q½Ð±Ð¡A¤p§Ì·Q§ï¬°3001-3003¡A5001-5003(¤£­na¡A§ï¬°¥þ¼Æ¦r)¡C½Ð«ü±Ð¡I

TOP

SUMIF(A1:A6,">=3001",B1:B6)-SUMIF(A1:A6,">3003",B1:B6)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 4# tinching


´N¦p¿z¿ï±ø¥ó"¼Æ¦r"¥u¯à¥Î¤j©ó¡B¤p©ó¡Bµ¥©ó¡B...
"¤å¦r"¥i¥H¥Î¶}ÀY¥H¡Bµ²§ô¥H¡Bµ¥©ó¡B... ©Ò¥H
C1=SUMIF(A1:A6,"<4000",B1:B6)
C2=SUMIF(A1:A6,">4000",B1:B6)

TOP

´X¦ì¤j¤jªºµª®×¥þ³£¥i¦æ¡A·PÁ«ü±Ð¡I

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD