- ©«¤l
- 824
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 904
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2023-12-24
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2010-8-8 12:15 ½s¿è
¸gÆ[¹î§Aªº
A4 = SUMPRODUCT(0,8,0,0,6,0,0,0,0,...})
¥ç§Y±N C1,F1,I1,... ¥[Á` (¦]¬° "®tÃB" ¥u·|¦bB1,E1,H1...²£¥Í,©Ò¥H¦bA4À³µL§@¥Î)
A6 = SUMPRODUCT({0,0,2,0,0,2,0,0,0,...})
¥ç§Y±N D1,G1,J1,... ¥[Á` (²z¥Ñ¦P¤W)
©Ò¥H§Ú²q§Anªº¬O©³¤Uªº¤½¦¡
A11=A4/(COUNTA($B$1IV$1)/3)
A14=A6/(COUNTA($B$1IV$1)/3)
¥t¥~¦]¬° A8=A4-A6 ¥ç§Y¬°¨âÓ¥[Á`¼Æ¦rªº®tÃB,
¦ü¥G»P "®tÃB" ªºÓ¼ÆµLÃö,
³o¸Ì¤£¤Ó²M·¡§A¥Î COUNTIF(B1:AI1,"®tÃB") ·í¤À¥Àªºì¦]. |
|