å°æ¬¾å¼ç¸åçæ°æ®ç¸å ï¼å¯ä»¥ç¨æ¡ä»¶æ±åå½æ°sumifæ¥å®ç°è¿æ ·çææã
示ä¾æ°æ®ï¼
å¦ä¸å¾æ示ï¼E2åå æ ¼çå ¬å¼ä¸ºï¼=SUMIF(A2:A13,D2,B2:B13)ãsumifå½æ°ä¸ºæ¡ä»¶æ±åå½æ°ï¼å¯ä»¥å°ç¸åååçæ°æ®å¿«éæ±æ»ã该å½æ°ç第ä¸ä¸ªåæ°ä¸ºæ¡ä»¶åºåï¼ç¬¬äºä¸ªåæ°ä¸ºæ¡ä»¶ï¼ç¬¬ä¸ä¸ªåæ°ä¸ºæ±ååºåï¼ææå°±æ¯å¨æ¡ä»¶åºåä¸ï¼æ¾å°ç¬¦åä¸è¡£çå¼ï¼å¹¶å¯¹ä¸è¡£å¯¹åºçæ°éè¿è¡æ±åã