- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
ªþ¥ó :
¨ç¼Æ_¹ïÀ³¼Æ¦rªºÓ¼Æ²Îp.rar (25.77 KB)
¬Q¤Ñ¦³¸Õ¼g¤½¦¡ :
AI4
=IF(SUMPRODUCT(($Z$2:$Z51=$AH4)*($AA$2:$AF$51=AI$3)*1)=0,"",SUMPRODUCT(($Z$2:$Z51=$AH4)*($AA$2:$AF$51=AI$3)*1))
¦ý¥u¦³AI4:BU4(²Ä4¦C)ªºµª®×¥¿½T¡A¤U©Ô«áªºµª®×¥þ³¡=#N/A¡A
Àµ½Ð¦U¦ì¤j¤j¸Ñ´b¡CÁÂÁÂ!
|
|