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

[µo°Ý] ¦¹°ÝÃD¥i¯à¦^Áç¡AÃö©ó¤H¼Æ+¦¸¼Æ²Î­p

[µo°Ý] ¦¹°ÝÃD¥i¯à¦^Áç¡AÃö©ó¤H¼Æ+¦¸¼Æ²Î­p

¥»©«³Ì«á¥Ñ av8d ©ó 2013-1-16 12:02 ½s¿è

B1=2
D1=¥Ò

B1~B200¬O¶Ã¼Æ
D1~D200¬O¤å¦r¶Ã¼Æ

°²¦p
B1=2
B2=3
B3=4
D1=¥Ò
D2=¤A
D3=¥Ò
¥H¦¹Ãþ±À

¸Ó¦p¦óÅýÅã¥Ü ¥Òªº¼Æ¶q = 6 , ¤Aªº¼Æ¶q = 3

12:02 §ä¨ìµª®×¤F~SUMIFªº¥Îªk~ÁÂÁ¦U¦ì¤j¤jªºÆ[¬Ý!

=SUMIF(D:D,"¥Ò",B$1)

TOP

¥»©«³Ì«á¥Ñ loquat ©ó 2013-2-22 14:21 ½s¿è
  1. {=SUM(IF(D1:D3="¥Ò",B1:B3,))}
  2. =SUMPRODUCT(N(D1:D3="¥Ò"),B1:B3)
  3. =SUMPRODUCT(--(D1:D3="¥Ò"),B1:B3)
  4. =SUMPRODUCT((D1:D3="¥Ò")*1,B1:B3)
½Æ»s¥N½X
¦V°ª¤â学习

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD