- B7=IF(COUNTIF(1:1,8)=0,,COUNTIF(1:1,A7))+IF(COUNTIF(2:2,8)=0,,COUNTIF(2:2,A7))+IF(COUNTIF(3:3,8)=0,,COUNTIF(3:3,A7))+IF(COUNTIF(4:4,8)=0,,COUNTIF(4:4,A7))+IF(COUNTIF(5:5,8)=0,,COUNTIF(5:5,A7))
½Æ»s¥N½X ¦pªG²Ä¤@¦C¦³¥X²{8ªº¸Ü¡A´NpºâA7¥X²{ªº¦¸¼Æ
²Ä¤G¦C¦³¥X²{8ªº¸Ü¡A´NpºâA7¥X²{ªº¦¸¼Æ
¤@ª½¨ì²Ä5¦C
5¦Cpºâ¥X²{ªºÈ¬Û¥[
³o¬q¨ç¼Æ¸Ó«ç»ò²¤Æ¡H |