| ·¢»õÆÚÏÞ: ×ÔÂò¼Ò¸¶¿îÖ®ÈÕÆð ÌìÄÚ·¢»õ | ËùÔÚµØ: ºÓÄÏ ÐÂÏçÊÐ |
| ÓÐЧÆÚÖÁ£º ³¤ÆÚÓÐЧ | Æ·ÅÆ£ºÐÂÏç»á¼ÆÖ¤ÅàѵѧУ |
ÏêÇé½éÉÜ


£¨6£©AVERAGEIF



£¨1£©ÆóÒµÒÑÊÕ¿î¼ÇÕË£¬ÒøÐÐδÊÕ¿îδ¼ÇÕ˵ĿîÏËÄ¡¢×Ü·ÖÀàÕË»§ÓëÃ÷ϸ·ÖÀàÕË»§µÄƽÐеǼǣ¨6£©AVERAGEIF
| ·¢»õÆÚÏÞ: ×ÔÂò¼Ò¸¶¿îÖ®ÈÕÆð ÌìÄÚ·¢»õ | ËùÔÚµØ: ºÓÄÏ ÐÂÏçÊÐ |
| ÓÐЧÆÚÖÁ£º ³¤ÆÚÓÐЧ | Æ·ÅÆ£ºÐÂÏç»á¼ÆÖ¤ÅàѵѧУ |

