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

½Ð±Ð°}¦C¤½¦¡(¨Ì¤£¦P±ø¥ó)¡G¨D³Ì¤j­È¡B³Ì¤p­È¤Î¥­§¡­È(Max,min,Average)

½Ð±Ð°}¦C¤½¦¡(¨Ì¤£¦P±ø¥ó)¡G¨D³Ì¤j­È¡B³Ì¤p­È¤Î¥­§¡­È(Max,min,Average)

ªþ¥ó¤¤¡A¶µ¥Ø­Ó¼Æ¥i¥H¥ÎSumproduct°µ¥Xµª®×¨Ó¡C
¦ý·Q­n¥ÎSumproductªº¤èªk¨Ó®M¥Î°µ Max®É´N¦³°ÝÃD
½Ð°Ý¦³¨S¦³Â²©öªº¤èªk°µ¥X¸ê®Æ¨Ó¡A²{¦³¸ê®Æ¬O¥Î¤â¤u°µªº

Data.zip (2.85 KB)

¥»©«³Ì«á¥Ñ jackdream ©ó 2010-8-16 15:17 ½s¿è

¸Õ¸Õ¬Ý§a~

°}¦C¤½¦¡(°O±o¥Î Ctrl + Shift + Enter)
³Ì¤j­È {=MAX(($B$2:$B$33="½Þ")*($C$2:$C$33="¦×")*($D$2:$D$33))}

¥Î sumproduct ¤è¦¡(¤£»Ý Ctrl + Shift + Enter)
³Ì¤j­È=SUMPRODUCT(MAX(($B$2:$B$33="½Þ")*($C$2:$C$33="¦×")*($D$2:$D$33)))

TOP

ÁÂÁ¡Ijackdream ¡T
sumproduct ³o­Ó¤èªk¸û¦X§Ú¥Î¡C
­ì¨Ó§Ú¬O¥Î¦¨MAX(SUMPRODUCT¡A¦Ó¤£¬O¥ÎSUMPRODUCT(MAX¡C
³o¼Ë¤w¥i¥H¸Ñ¨M§Úªº°ÝÃD¤F¡C

TOP

¥»©«³Ì«á¥Ñ ¦Ñ®L ©ó 2010-8-16 15:41 ½s¿è

¤S¬O¤@­Ó³Q»~¾É±o¨Ï¥ÎªÌ,¤£©Ç±z
¤¤¤F[¼CÅ]]¾l¬r,¨«¤õ¤JÅ]
************************************

Subtotal()¨ú¥N24ºØ¨ç¼Æ¥\¯à
°t¦X¦Û°Ê¿z¿ï¨Ï¥Î
¬d¸ß§½³¡²Î­p¸ê®Æ
************************************
¬d¸ß¥þ³¡§½³¡²Î­p¸ê®Æ
¨Ï¥Î¼Ï¯Ã¤ÀªRªí

Data.rar (41.3 KB)

TOP

¥i¬O§â Max  §ï¬°  min ¨ç¼Æ®É¡A¸ê®Æ´N¤£¹ï¤F¡C
¶]¥X¨Óªº¬O 0.00%
½Ð°Ý³o¬O¨ºùئ³°ÝÃD¡C

TOP

¦^´_ 5# Baracuda

¥i¥H°Ñ¦Ò¦Ñ®L«e½úªº§@ªk,±N¸ê®Æ¥¿³W¤Æ¦A¶i¦æ¼Ï¯Ã
­Y¤£§ïÅܸê®Æ®æ¦¡,¥i°Ñ¦Ò°}¦C¤½¦¡(Ctrl + Shift + Enter)
³Ì¤j­È
{=MAX(IF(($B$2:$B$33="½Þ")*($C$2:$C$33="¦×"),$D$2:$D$33))}
³Ì¤p­È
{=MIN(IF(($B$2:$B$33="½Þ")*($C$2:$C$33="¦×"),$D$2:$D$33))}
¥­§¡
{=AVERAGE(IF(($B$2:$B$33="½Þ")*($C$2:$C$33="¦×"),$D$2:$D$33))}

TOP

G3=MAX(($B$2:$B$33=LEFT(F3))*($C$2:$C$33=MID(F3,2,2))*(($D$2:$D$33)))
H3=MIN(IF(($B$2:$B$33=LEFT(F3))*($C$2:$C$33=MID(F3,2,2))*(($D$2:$D$33)),($B$2:$B$33=LEFT(F3))*($C$2:$C$33=MID(F3,2,2))*(($D$2:$D$33)),100))
I3=AVERAGE(($B$2:$B$33=LEFT(F3))*($C$2:$C$33=MID(F3,2,2))*(($D$2:$D$33)))
¥H¤W³£¬O°}¦C¤½¦¡,©¹¤UCOPY

TOP

jackdream  ¯x°}¤½¦¡Work ¡A¦ý¬O³o­Ó¤ñ¸û³Â·Ð¡A­n¥[¤uªº³¡¤À¤ñ¸û¦h¡C
¤£¹L¥i¥H¥Î¡C

ANGELA §Aªº¤½¦¡¬Ý¨Ó¥þµM¤£ Work

TOP

¦Ñ®L
¼Ï¯Ã¤ÀªRªíªº¤è¦¡¥i¥H°µ¨ì¡C
¤¤¤F[¼CÅ]]¾l¬r,¨«¤õ¤JÅ]¡A³o¬q®¤¦b¤U¤~²¨¾Ç²L¡A¯uªº¬Ý¤£À´¡C

TOP

³o­Ó°ÝÃD¦b¦U¦ìªº§V¤O¸Ñµª¤§¤U¤w¸g¸Ñ¨M¤F¡CÁÂÁ¤j®a¡C
¦Ñ®L«e½úªº¤èªk§Ú¤]ª¾¹D¥i¥H¥Î(¦ý¦Ñ®L«e½ú¥Îªº¤ñ§Ú¦n)¡C
¥i¬O¦]¬°¤À¡u ­ì®Æ¡v¡B¡u ¦¨«~¦WºÙ¡v¬O¦]¬°ÁÙ­n¥h°lÂÜ­ì®Æªº³¡¤À¡A©Ò¥H¤~¤£§â2­ÓÄæ¦ì¦X¨Ö¡C
©Ò¥H¦Ñ®L«e½úªº¸Ñµª¤]¬O¥i¥Î¡A¥u¬O­n¦h°µ¤@¦¸¦X¨ÖÄæ¦ìªº¥\¤Ò¡C

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD