µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» COUNTIFS²Îp½Æ¼Æ±ø¥ó°ÝÃD
 
1
2
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
COUNTIFS²Îp½Æ¼Æ±ø¥ó°ÝÃD
msmplay
µoµu®ø®§
¥[¬°¦n¤Í
msmplay
·í«eÂ÷½u
UID
17535
©«¤l
218
¥DÃD
73
ºëµØ
0
¿n¤À
290
ª÷¿ú
290
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
177 ¤p®É
µù¥U®É¶¡
2014-5-19
³Ì«áµn¿ý
2022-11-29
¤¤¾Ç¥Í
©«¤l
218
¥DÃD
73
ºëµØ
0
¿n¤À
290
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2014-5-19
³Ì«áµn¿ý
2022-11-29
4
#
¸õÂà¨ì
»
µoªí©ó 2016-6-4 20:26
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ msmplay ©ó 2016-6-4 20:28 ½s¿è
¦^´_
2#
KCC
K¤j~~~~¶W¯Å·PÁ±z¡A´ú¸Õ¥i¦æ³á!!!¦ý¤p©f¥i¥H¦A½Ð±Ð¤@¤U2Ó°ÝÃD¶Ü??
´N¬O{
"´«³f"
;
"*DOA*"}<<¤¤¶¡ªº , §ï ; ¬O¤°»òì²z¤X!?¦]¬°§Ú¬d¨ç¼Æ»¡©ú¦n¹³¤]¨SÂ檺¥ÎªkC!!
µM«á¦pªG³sCÄæ¤]»Ýn¦h±ø¥ó²Îpªº¸Ü¡A¬O¤£¬O´N¤£¾A¥Î¥H¤W¥Îªk??
¨Ò¦p:CÄæ¨Ó·½¥¼¨Ó¤£¥u¦³"ªù¥«"»P"ºô¸ô"®É¡A¥i¯à¦³¦hÓ¨Ó·½¡A¦ýCÄæ¥u»Ý²Îp
"ªù¥«"»P"ºô¸ô"¡A¤½¦¡×§ï¦p¤U«oµLªk²Îp¥¿½T¼Æ¦r
=SUM(COUNTIFS(A:A,{"´«³f"
;
"*DOA*"},B:B,{"*µLªk¶}¾÷*","*½Ý½u*","*¾î½u*"},C:C,{"ªù¥«";
"ºô¸ô"}
))
¤U¸ü
(39.81 KB)
2016-6-4 20:27
*¦v¤k¤@ªTµL»~*
TOP
hcm19522
µoµu®ø®§
¥[¬°¦n¤Í
hcm19522
·í«eÂ÷½u
UID
22069
©«¤l
1360
¥DÃD
4
ºëµØ
0
¿n¤À
1370
ª÷¿ú
1370
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
1700 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-4-19
¤j¾Ç¥Í
©«¤l
1360
¥DÃD
4
ºëµØ
0
¿n¤À
1370
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-4-19
3
#
µoªí©ó 2016-6-4 17:43
|
¥u¬Ý¸Ó§@ªÌ
¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-6-4 17:56 ½s¿è
»²§U D2 ¤U©Ô=IF(((A2="´«³f")+COUNTIF(A2,"*DOA*"))*MMULT(ISNUMBER(FIND({"µLªk¶}¾÷","½Ý½u","¾î½u"},B2))*1,{1;1;1})*(C2="ªù¥«")>0,1,)
E7=SUM(D:D)
³]»²§U ¸ê®Æ¦h À³³t«×§Ö
TOP
KCC
µoµu®ø®§
¥[¬°¦n¤Í
KCC
·í«eÂ÷½u
UID
21955
©«¤l
85
¥DÃD
0
ºëµØ
0
¿n¤À
126
ª÷¿ú
126
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
452 ¤p®É
µù¥U®É¶¡
2015-8-31
³Ì«áµn¿ý
2022-4-15
¤¤¾Ç¥Í
©«¤l
85
¥DÃD
0
ºëµØ
0
¿n¤À
126
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2015-8-31
³Ì«áµn¿ý
2022-4-15
2
#
µoªí©ó 2016-6-4 17:41
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
msmplay
=SUM(COUNTIFS(A:A,{"´«³f"
;
"*DOA*"},B:B,{"*µLªk¶}¾÷*","*½Ý½u*","*¾î½u*"},C:C,"ªù¥«"))
TOP
ÀR«ä¦Û¦b :
¤@ӯʤfªºªM¤l¡A¦pªG´«¤@Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
 
1
2
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·