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

application.sumif

application.sumif

A COLUMN ¬°¤é´Á  C COLUMN ¬°¼Æ¦r
·Q¥Î application.sumif   ¥[Á`9¤ë¥÷(C COLUMN)
µ{§Ç¦p¦ó¼g?

¦^´_ 1# t8899
  1. Option Explicit
  2. Sub EX()
  3.     Dim S_ALL As Single, I As Integer
  4.     I = 2
  5.     Do While Cells(I, "A") <> ""
  6.         If Month(Cells(I, "A")) = 9 Then S_ALL = S_ALL + Cells(I, "B")
  7.         I = I + 1
  8.     Loop
  9.     MsgBox S_ALL
  10. End Sub
½Æ»s¥N½X
¤u§@ªí¤Wªº¥[Á`
¥Î¸ê®Æ®w¥[Á`¨ç¼Æ,¥[Á`
   

¸ê®Æ®w·Ç«h³]¥ß
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-10-2 07:14 ½s¿è
¦^´_  t8899 ¤u§@ªí¤Wªº¥[Á`
¥Î¸ê®Æ®w¥[Á`¨ç¼Æ,¥[Á`
    ¸ê®Æ®w·Ç«h³]¥ß
GBKEE µoªí©ó 2014-10-2 06:31

¤F¸Ñ  
¤£¹L¡A§Ú¬O·Qª¾¹D application.sumif ªº¨Ï¥Î

msgbox application.sumif (range("a:a"), ???? ,range("c:c"))
¬õ¦â4­Ó°Ý¸¹ µ¥©ó9¤ë «ç»òªí¥Ü??¦pªG¬O¤j©ó9¤ë¡A¤S¬O¦p¦óªí¥Ü?

TOP

¦^´_ 3# t8899
¤u§@ªíSUMIF ªº·Ç«h: ¥u¥i¥H¥Î"> < = <>"ªº±ø¥ó¦¡­pºâ,¤£¥i¥H¥Î  MONTH(???)=? ªº¨ç¼Æ¦¡­pºâ.

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_  t8899
¤u§@ªíSUMIF ªº·Ç«h: ¥u¥i¥H¥Î"> < = "ªº±ø¥ó¦¡­pºâ,¤£¥i¥H¥Î  MONTH(???)=? ªº¨ç¼Æ¦¡­pºâ.
...
GBKEE µoªí©ó 2014-10-2 07:20

ÁÂÁÂ!
§Ú¬O¸Õ¤£¥X¨Ó¡A¤~¨Óµo°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD