建议æ¶èå¤ç¨ï¼ææ¶é´å¤ç»ä¹ ä¸ä¸ï¼æè½è¿
éææ¡å½æ°å½ä»¤ï¼å·¥ä½èµ·æ¥å¾å¿åºæã
ä¸ãå¤æå
¬å¼
1ãæå
¬å¼è¿åçé误å¼æ¾ç¤ºä¸ºç©º
å
¬å¼ï¼C2=IFERROR(A2/B2,"")
说æï¼å¦ææ¯é误å¼åæ¾ç¤ºä¸ºç©ºï¼å¦åæ£å¸¸æ¾ç¤ºã
æå
¬å¼è¿åçé误å¼æ¾ç¤ºä¸ºç©º
2ãIFçå¤æ¡ä»¶å¤æ
å
¬å¼ï¼C2=IF(AND(A2<500,B2="æªå°æ"),"补款","")
说æï¼ä¸¤ä¸ªæ¡ä»¶åæ¶æç«ç¨AND,ä»»ä¸ä¸ªæç«ç¨ORå½æ°ã
IFçå¤æ¡ä»¶å¤æ
äºãç»è®¡å
¬å¼
3ãç»è®¡ä¸¤è¡¨éå¤
å
¬å¼ï¼B2=COUNTIF(Sheet15!A:A,A2)
说æï¼å¦æè¿åå¼å¤§äº0说æå¨å¦ä¸ä¸ªè¡¨ä¸åå¨ï¼0åä¸åå¨ã
ç»è®¡ä¸¤è¡¨éå¤
4ãç»è®¡å¹´é¾å¨30~40ä¹é´çå工个æ°
å
¬å¼ï¼=FREQUENCY(D2:D8,{40,29})
ç»è®¡å¹´é¾å¨30~40ä¹é´çå工个æ°
5ãç»è®¡ä¸éå¤çæ»äººæ°
å
¬å¼ï¼C2=SUMPRODUCT(1/COUNTIF(A2:A8,A2:A8))
说æï¼ç¨COUNTIFç»è®¡åºæ¯äººçåºç°æ¬¡æ°ï¼ç¨1é¤çæ¹å¼æåºç°æ¬¡æ°åæåæ¯ï¼ç¶åç¸å ã
ç»è®¡ä¸éå¤çæ»äººæ°
6ãæå¤æ¡ä»¶ç»è®¡å¹³åå¼
F2å
¬å¼ï¼=AVERAGEIFS(D:D,B:B,"è´¢å¡",C:C,"大ä¸")
æå¤æ¡ä»¶ç»è®¡å¹³åå¼
7ãä¸å½å¼æåå
¬å¼
å
¬å¼ï¼=SUMPRODUCT(($D$4:$D$9>=D4)*(1/COUNTIF(D$4:D$9,D$4:D$9)))
äºãæ°åå¤ç
8ãåç»å¯¹å¼ï¼=ABS(æ°å)
9ãæ°ååæ´ï¼=INT(æ°å)
10ãæ°ååèäºå
¥ï¼=ROUND(æ°å,å°æ°ä½æ°)
åãæ±åå
¬å¼
11ãéåæ±å
å
¬å¼ï¼H3=SUMIF($A$2:$G$2,H$2,A3:G3)
æ=SUMPRODUCT((MOD(COLUMN(B3:G3),2)=0)*B3:G3)
说æï¼å¦ææ é¢è¡æ²¡æè§åç¨ç¬¬2个å
¬å¼
éåæ±å
12ãåæ¡ä»¶æ±å
å
¬å¼ï¼F2=SUMIF(A:A,E2,C:C)
说æï¼SUMIFå½æ°çåºæ¬ç¨æ³
13ãåæ¡ä»¶æ¨¡ç³æ±å
å
¬å¼ï¼è¯¦è§ä¸å¾
说æï¼å¦æéè¦è¿è¡æ¨¡ç³æ±åï¼å°±éè¦ææ¡éé
符ç使ç¨ï¼å
¶ä¸æå·æ¯è¡¨ç¤ºä»»æå¤ä¸ªå符ï¼å¦"*A*"就表示aåååæä»»æå¤ä¸ªå符ï¼å³å
å«Aã
åæ¡ä»¶æ¨¡ç³æ±å
14ãå¤æ¡æ±æ¨¡ç³æ±å
å
¬å¼ï¼C11=SUMIFS(C2:C7,A2:A7,A11&"*",B2:B7,B11)
说æï¼å¨sumifsä¸å¯ä»¥ä½¿ç¨éé
符*
å¤æ¡æ±æ¨¡ç³æ±å
15ãå¤è¡¨ç¸åä½ç½®æ±å
å
¬å¼ï¼b2=SUM(Sheet1:Sheet19!B2)
说æï¼å¨è¡¨ä¸é´å é¤ææ·»å 表åï¼å
¬å¼ç»æä¼èªå¨æ´æ°ã
温馨提示:答案为网友推荐,仅供参考