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

sumifs Âন vba »yªk

sumifs Âন vba »yªk

Dear ¦U¦ì¥ý¶i¡A
§Ú¦³¼g¤F¨ç¼Æ
=SUMIFS(R5:R50,O5:O50,A5,P5:P50,B5,Q5:Q50,C5)

¦³§ä¤Fºô¸ô¼g¦¨VBAªº§@·~¡A¦ý¤´¤£À´¸Ó¦p¦ó¼gVBA

¬O§_¥i½Ð±Ð¦U¦ì¥ý¶i¡A±Ð¾É¤@¤U SUMIFS VBA »yªk

·P®¦!
Just do it.

¥»©«³Ì«á¥Ñ mdr0465 ©ó 2022-4-26 14:33 ½s¿è

¦^´_ 32# samwang

samwang®v¥S,§A¦n

¨ü±Ð¤F, ­ì¨Ó¬O§Ú¦b¹Bºâ¤W°µ¤F¦h¾lªº¨Æ±¡,

¸U¤À·P¿E«ü¾É§Úªº¿ù³B, ¤é«á¦pªG¤£À´ªº¦a¤è,¦A¬Ýsamwang ®v¥S½Ð±Ð

ÁÂÁÂ

TOP

¦^´_ 31# mdr0465

½Ð¬Ýªþ¥ó¡AÁÂÁÂ

Sumif VBA_0426.zip (23.3 KB)

TOP

¥»©«³Ì«á¥Ñ mdr0465 ©ó 2022-4-26 13:07 ½s¿è

¦^´_ 30# samwang


SAMWANG ®v¥S,§A¦n

§Ú³£¬Ý¨ì¸ê®Æ¦^¶ñ®É¤]¦³¿ù¦ì°ÝÃD, ¦ý§Ú¥Î·MÄøªº¤èªk§Ú­×¥¿¤F(½Ð¬Ý¥H¤U¬õ¦rªº¦a¤è), ³o¤@ÂI§Ú©l²×¤£©ú¥Õ·í¤¤¬O¬°¦ó³o¼Ë³]©w´N¥i¥H¸Ñ¨M, ½ÐSAMWANG «ü±Ð

.[A20:A21].EntireRow.Clear
    .[B20].Resize(1, xD2.Count) = xD2.Keys
    Crr = .[B20].CurrentRegion
    For x = 1 To UBound(Crr, 2)
        Crr(1, x) = xD(Crr(1, x) & "")
    Next

    .[B21].Resize(UBound(Crr), xD.Count - 4) = Crr
    .[A20] = "XX"
    .[A21] = "YY"

Sumif VBA.rar (24.6 KB)

SUMIF

TOP

¦^´_ 29# mdr0465


¥t¥~¡A¸ê®Æ¦^¶ñ®É¤]¦³¿ù¦ì°ÝÃD¡A¦hµ½¥ÎF8´N¥iª¾¹D°ÝÃD¦b­þ¸Ì¡AÁÂÁÂ

TOP

¦^´_ 28# samwang

SAMWANG®v¥S,§A¦n

ÁÂÁ§Aªº«ü¾É, §Ú·Q·Q«ç¼Ë¦b¦^¶ñ¸ê®Æ®É¥ýªºµª®×¥ý²M°£,

ÁÂÁ§A­@¤ß±Ð¾É, ÁÂÁÂ

TOP

¦^´_  samwang


samwang§A¦n
§Ú­É¥Î§Aªº§¹¦¨«~­×§ï¤@¤U, ±NsumifÅܦ¨¾î¦Vªº,²Ä¤@¦¸¹Bºâ¬O¦¨¥\ªº, ¦ý ...
mdr0465 µoªí©ó 2022-4-26 10:30


¦^¶ñ¸ê®Æ®É­n¥ýªºµª®×¥ý²M°£¡A§Ú·Q§AÀ³¸Óª¾¹D¦p¦ó°µ¡A¼g±o«Ü¦n¡A¦Û¤v¦b¸Õ¸Õ¬Ý¡AÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ mdr0465 ©ó 2022-4-26 10:31 ½s¿è

¦^´_ 26# samwang


samwang§A¦n
§Ú­É¥Î§Aªº§¹¦¨«~­×§ï¤@¤U, ±NsumifÅܦ¨¾î¦Vªº,²Ä¤@¦¸¹Bºâ¬O¦¨¥\ªº, ¦ý¤£ª¾¬°¦ó·í²Ä¤G¦¸¹Bºâ®É´N·|¥¢±Ñ, ½ÐÀ°¦£¬d¬Ý¨Ã«üÂI§Ú¿ù¦b¨º¨½,




ÁÂÁÂ

Sumif VBA.rar (24.19 KB)

TOP

¦^´_ 25# samwang
Dear samwang,
Thank you so much.·PÁ±zÅo¡I  ^_^
Just do it.

TOP

¦^´_  samwang
Dear samwang,
OK¡A¥i¥H¥Î¡C¦b»P±z½Ð±Ð¤@¤U¡A°õ¦æ«áH1Äæ¦ìªº"VBA"³£·|Åܦ¨ªÅ¥Õ¡C
¬O§_¥i ...
jsc0518 µoªí©ó 2021-12-10 15:03


   .[h1].Resize(UBound(Brr)) = Brr
    .[h1] = "VBA"
End With

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD