ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð±Ð³]©w®æ¦¡¤ÆÃC¦â°ÝÃD

½Ð±Ð³]©w®æ¦¡¤ÆÃC¦â°ÝÃD

¦pªG¬OÀx¦s®æ¦Û¦æ³]©wÃC¦â¥i¥H¥ÎGet.cell¨ç¼Æ§ä¥XÃC¦â¸¹½X­pºâ¼Æ¶q
¦ý¥Ñ³]©w®æ¦¡¤Æ²£¥ÍªºÃC¦âµLªk¨Ï¥ÎGet.cell§ä¥XÃC¦â¸¹½X
½Ð°Ý¦³¤°»ò¤èªk¥i¥H§ä¥X³]©w®æ¦¡¤ÆÃC¦âªº¸¹½X??

¦]¤½¥q­­¨îµLªk¤W¶ÇÀÉ®×,½Ð¦h¥]²[

¥i¥Hª½±µ¥Î®æ¦¡¤Æ±ø¥ó¤½¦¡¥h²Î­p,
¨S¦³ÀÉ®×, À°¤£¤W~~

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522

test.JPG
2019-7-3 07:13

   
»P¨ä¥LÄæ¦ì¤ñ¹ï¦ü¥G¤£¦æ
F2:F4=SUMPRODUCT(N($B$2:$B$13>($C$2:$C$13*0.9))=2-COLUMN(A1))

TOP

¦^´_ 3# hcm19522

ÁÂÁ§Aªº«ü±Ð
¥Ø«e§ï¦¨³o¼Ë¥i¥Hºâ¥X¦U¶µ¼Æ¶q
=SUMPRODUCT(($B$2:$B$13>($C$2:$C$13*0.9))*(ISNUMBER(FIND("¤èªk",$A$2:$A$13))))

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD