at58441215

¦^´_ 11# register313


    ¤F¸Ñ~·PÁ´£¿ô    §Ú±`±`¤£¬O§Ñ¤F¥[¬A©·´N¬O§Ñ¤F¥[¨M¹ï­È ;P

register313

¦^´_ 10# at58441215

1.¬Û¹ï¦ì§},µ´¹ï¦ì§}¤§¨Ï¥Î­nª`·N
  ³Ì«á$G$2:$G$22­n¥Îµ´¹ï¦ì§}
2.¤@­ÓÃD¥Ø¥»¨Ó´N·|¦³«Ü¦h¸Ñªk,¼ô½mªº¤èªk³Ì¦n¥Î

at58441215

DEAR REGISTER ¤j¤j
¬Oªº§Ú¬O¥Î³o¼Ëªº¤½¦¡¦^ÂЪº
¤@¯ë§@¦h±ø¥ó¦¡¿z¿ï §Ú³£¥u·|¥Îsumproduct  ¤ñ¸û¤£ª¾¹D¦p¦ó¨Ï¥ÎINDEX©ÎIF(ISERROR(LOOKUP ...) ½Ð°Ý³o´XºØ®t­þ¸Ì ­þºØ¤è¦¡¤ñ¸û¦n¨Ï¥Î©O?

register313

¦^´_ 8# at58441215

C2=SUMPRODUCT(($E$2:$E$22=A2)*($F$2:$F$22=B2)*($G$2:$G$22))

at58441215

¬O§_¤]¥i¥H¥ÎSUMPRODUCT ©O  ¦p¤U¡G

¤U¸ü (97.3 KB)

2012-3-25 20:10

register313

¦^´_ 6# jimmuLu

¨S¿ù
¥Î¨ì¹ï·ÓªíE2:G22ªº¦a¤è,¨ä¦C¦ì§}³£­n¥Îµ´¹ï($)
¤£µM©¹¤U½Æ»s¤½¦¡®É,¨ä¹ïÀ³ªº¹ï·Óªí·|³v¦C©¹¤U²¾

jimmuLu

¦^´_ 3# renzhi2020


    C2  ­Y=IF(ISERROR(LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)))),0,LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)),(G2:G22)))

­n½Æ»s®É¦n¹³´N¦³°ÝÃD

¬O§_À³¥[¤W$  C2=IF(ISERROR(LOOKUP(2,1/((E$2:E$22=A2)*(F$2:F$22=B2)))),0,LOOKUP(2,1/((E$2:E$22=A2)*(F$2:F$22=B2)),(G$2:G$22)))

½Æ»s®É¸û¤è«K

meet0718

¯uªº¦³¸Ñ¨M§Úªº°ÝÃD¤F¡A°ÝÃD§xÂZ¤F§Ú¦n¤[¡A¹ï¨â¦ì¯u¬O·P¿E¤£ºÉ!

meet0718

§Ú¨Ó¸Õ¸Õ¬Ý¡A¬Ý¶]¥X¨Óµ²ªG¦p¦ó!ÁÂÁÂ!

renzhi2020

¦^´_ 2# register313

¥H«e Hsieh sir ±Ðªº
=IF(ISERROR(LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)))),0,LOOKUP(2,1/((E2:E22=A2)*(F2:F22=B2)),(G2:G22)))