- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-6-26 15:23 ½s¿è
¦^´_ starry1314
¨ú²Ä2½X»P²Ä5½X¤ñ¸û
D3 =SUMPRODUCT(1/COUNTIF(rng,rng)*(MMULT((MID(rng,{2,5},1)=MID(D$2,{1,2},1))*1,{1;1})=2))
¥k©Ô
J3 =SUM(D3:I3)
K3 =SUMIF(D2:I2,"?V",D3:I3)
ML089 µoªí©ó 2015-4-29 09:02 [/quote]
¤j¤j~¤£¦n·N«ä
·Q½Ð°Ý 01Q001AV ³o¼Ëªº®æ¦¡n¦p¦ó§ï©O? ²Ä8½X¤£¤@©w¦³
12A002BV
01Q002A
D3 =SUMPRODUCT(1/COUNTIF(rng,rng)*(MMULT((MID(rng,{3,7},1)=MID(D$2,{1,2},1))*1,{1;1})=2))
¦ýµLªkpºâ©O?
«ü©w±ø¥ó ¤£«½Æ.rar (8.1 KB)
[quote] |
|