é®é¢çä¼¼ç®åï¼ä½ç¼è¾å
¬å¼å´è¿æ¯é¢æé¾åº¦ãè±äº1个å¤å°æ¶ï¼å°æªè¾¾å°âè¶ç®åè¶å¥½âä¹è¦æ±ï¼å
¬å¼å¦ä¸ï¼
F1ä¸çå
¬å¼ï¼
=SUM((N(INDIRECT("R"&ROW($2:$27)&"C"&COLUMN($B:$D),))>0)*(N(OFFSET(INDIRECT("R"&ROW($2:$27)&"C"&COLUMN($B:$D),),-1,,))=0)*(N(OFFSET(INDIRECT("R"&ROW($2:$27)&"C"&COLUMN($B:$D),),1,,))=0))
åæ¶æCtrl+Shift+Enterä¸é®è¾å
¥æ°ç»å
¬å¼
G1ä¸çå
¬å¼ï¼
=SUM((N(INDIRECT("R"&ROW($2:$26)&"C"&COLUMN($B:$D),))>0)*(N(INDIRECT("R"&ROW($3:$27)&"C"&COLUMN($B:$D),))>0)*(N(OFFSET(INDIRECT("R"&ROW($2:$26)&"C"&COLUMN($B:$D),),-1,,))=0)*(N(OFFSET(INDIRECT("R"&ROW($3:$27)&"C"&COLUMN($B:$D),),1,,))=0))
H1ä¸çå
¬å¼ï¼
=SUM((N(INDIRECT("R"&ROW($2:$25)&"C"&COLUMN($B:$D),))>0)*(N(INDIRECT("R"&ROW($3:$26)&"C"&COLUMN($B:$D),))>0)*(N(INDIRECT("R"&ROW($4:$27)&"C"&COLUMN($B:$D),))>0)*(N(OFFSET(INDIRECT("R"&ROW($2:$25)&"C"&COLUMN($B:$D),),-1,,))=0)*(N(OFFSET(INDIRECT("R"&ROW($4:$27)&"C"&COLUMN($B:$D),),1,,))=0))
å为æ°ç»å
¬å¼ã
æå¾
é«æç»åºæ´ç®åçå
¬å¼ã
温馨提示:答案为网友推荐,仅供参考