- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 245
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-11
|
¦^´_ 13# konkon3141
¦Û©w¸q¨ç¼Æ- Function All_Data(sh As Range, sh1 As Range, MyType As Integer) As Double
- Application.Volatile
- For Each sht In Sheets
- If sht.Name <> sh.Parent.Name And sht.Name <> sh1.Parent.Name Then
- Rng = sh.Address(, , , , 0)
- Rng1 = sh1.Address(, , , , 0)
- Select Case MyType
- Case 0
- All_Data = All_Data + 1
- Case Else
- All_Data = All_Data + (Application.CountA(sht.Range(Rng)) - Application.CountA(sht.Range(Rng1)))
- End Select
- End If
- Next
- End Function
½Æ»s¥N½X C9=All_Data(A1,ªÅ¥Õ®æ¦¡!A1,0)
C10=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!B:B,ªÅ¥Õ®æ¦¡!B$1:B$8,1)
C11=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!J:J,ªÅ¥Õ®æ¦¡!J$1:J$8,1)
C12=All_Data('¥Ø¿ý&¼Ò¨ã«~¦W'!P:P,ªÅ¥Õ®æ¦¡!P$1:P$8,1)
¼Ò¨ã¼i¾ú.rar (46.42 KB)
|
|