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


SUMIF£¨range£¬criteria£¬sum_range£©ÓÃÓÚ¶ÔÂú×ãÌõ¼þµÄµ¥Ôª¸ñÇóºÍ¡£



1.´Ó¼Û¶¨ÂÊÕ÷ÊÕ£¬¼´¸ù¾Ý²»Í¬µÄӦ˰Ïû·ÑÆ·È·¶¨²»Í¬µÄ±ÈÀý˰ÂÊ¡£»ìºÏÏúÊÛÊÇÖ¸Ò»ÏîÏúÊÛÐÐΪ¼ÈÉæ¼°»õÎïÏúÊÛÓÖÉæ¼°Ìṩ·ÇÔöֵ˰Ӧ˰ÀÍ
| ·¢»õÆÚÏÞ: ×ÔÂò¼Ò¸¶¿îÖ®ÈÕÆð ÌìÄÚ·¢»õ | ËùÔÚµØ: ËÄ´¨ ÄϳäÊÐ |
| ÓÐЧÆÚÖÁ£º ³¤ÆÚÓÐЧ | Æ·ÅÆ£ºÄϳä»á¼Æ´ÓÒµ×ʸñÖ¤ÅàѵѧУ |

