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

­pºâ¦U¶µ¥­§¡­È

­pºâ¦U¶µ¥­§¡­È

k3=SUMPRODUCT(($D$2:$D$42=K$2)*($B$2:$B$42=$H3)*($E$2:$E42))
¥i¥H­pºâ¦U¶µÁ`©M,½Ð°Ý¥i§_­pºâ¥­§¡­È,ÁÂÁÂ

=SUMPRODUCT(($B$2:$B$43=H3)*($D$2:$D$43=K2),($E$2:$E$43))/SUMPRODUCT(($B$2:$B$43=H3)*($D$2:$D$43=K2))
¥i¸Õ¸ÕDAVERAGE
¦pªþ¥ó
¬¡­¶Ã¯1.zip (4.27 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°Ý¥i§_­pºâ³Ìªñ3¤Ñ7¤Ñ....¥­§¡­È DIA.rar (5.23 KB)

TOP

ªþ¥óªºÀɮקA°Ñ¦Ò¬Ý¬Ý inquiryDemo.rar (30.07 KB)
¶È´£¨Ñ°Ñ¦Ò¤èªk¡A¦]¬°§Ú¤£¯à¤U¸ü§AªºÀÉ®×
1

µû¤À¤H¼Æ

    • Hsieh: «Ü¦nªº¤èªk¹B¥Îª÷¿ú + 4
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD