- ©«¤l
- 913
- ¥DÃD
- 150
- ºëµØ
- 0
- ¿n¤À
- 1089
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-28
- ³Ì«áµn¿ý
- 2023-7-19
|
¦^´_ 7# ANGELA
¦^´_ 6# ANGELA
ÁÂÁÂ7¼ÓªºªB¤Í,¤½¦¡¨S¦³°ÝÃD,§ÚÁÙ¨S¦³¥Î¹L"lookup",§A¥i¥H¸ò§Ú¸ÑÄÀ¨Ï¥ÎÅÞ¿è¶Ü?³o¼Ë¤~¯à¦³²M·¡ªº°O¾Ð,¥ýÁÂÁ§A¤F!
¦]¬°§Ú»Ýnªº¬O±a"¥X³f¤é´Á",6¼ÓªB¤Íªº¤½¦¡µy¥[קï«á¤]¬O¥i¥H¥Îªº.
L7=IF(SUMPRODUCT((¥X³f!$A$2:$A$1000=B7)*(¥X³f!$I$2:$I$1000=G7)*(¥X³f!$B$2:$B$1000=E7),¥X³f!$H$2:$H$1000)=0,"",SUMPRODUCT((¥X³f!$A$2:$A$1000=B7)*(¥X³f!$I$2:$I$1000=G7)*(¥X³f!$B$2:$B$1000=E7),¥X³f!$H$2:$H$1000))
·PÁ¦U¦ìªº¼ö¤ß:$ |
|