±ý¨D¨âÓ«D³sÄò°Ï¶¡ªº¥§¡È¡A½Ð¦U¦ì¤j¤jÀ°¦£¡AÁÂÁ±z~~
- ©«¤l
- 163
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 193
- ÂI¦W
- 0
- §@·~¨t²Î
- winsows 10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-20
- ³Ì«áµn¿ý
- 2024-5-9
|
±ý¨D¨âÓ«D³sÄò°Ï¶¡ªº¥§¡È¡A½Ð¦U¦ì¤j¤jÀ°¦£¡AÁÂÁ±z~~
±ý¨D¨âÓ«D³sÄò°Ï¶¡ªº¡y¥§¡È¡z¡A¨ä¤¤§t¡uªÅ¥ÕÈ¡v¤Î¡u0È¡v¡A³o¨âÃþ³£¤£npºâ¡A½Ð¦U¦ì¤j¤jÀ°¦£¤@¤U¡AÁÂÁ±z~~
[attach]37303[/attach][attach]37303[/attach]
[attach]37304[/attach][attach]37304[/attach] |
|
peter460191
|
|
|
|
|
- ©«¤l
- 163
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 193
- ÂI¦W
- 0
- §@·~¨t²Î
- winsows 10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-20
- ³Ì«áµn¿ý
- 2024-5-9
|
|
peter460191
|
|
|
|
|
- ©«¤l
- 1440
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1464
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-8-22
|
¥»©«³Ì«á¥Ñ Andy2483 ©ó 2024-1-18 11:39 ½s¿è
¦^´_ 1# peter460191
¹Ï¤ùµLªkÅã¥Ü
Option Explicit
Sub TEST()
Dim xU As Range, xA, N&, xR As Range, V
Set xU = Union([R6:R9, R13:R17], Range([S6], [S65536].End(3)))
For Each xR In xU
If Val(xR) <> 0 Then N = N + 1: V = V + Val(xR)
Next
If N > 0 Then MsgBox V / N
End Sub |
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|