AW: Was brauchst Du...
29.11.2021 10:32:51
UweD
Hallo nochmal
zum Letzten Punkt:
- Streng genommen sind alle Zahlen durch den Wert in C19 teilbar. Jedoch nicht alle ohne Rest
- ich denke es ist Restlos gemeint
Hier mal alles...
Sub Zählen()
Dim RNG As Range
Dim MMit As Range, MMax As Range, Mmin As Range
Dim Suchzelle As Range, c
Dim WF, Z, SSum As Long
Set WF = WorksheetFunction
With Sheets("Tabelle1")
Set RNG = .Range("F7:FA424")
Set MMit = .Range("C4")
Set MMax = .Range("C7")
Set Mmin = .Range("C13")
Set Suchzelle = .Range("C19")
End With
'reset
Union(MMit, MMax.Resize(3, 1), Mmin.Resize(3, 1), Suchzelle.Offset(1).Resize(3, 1)).ClearContents
With MMit
.Value = WF.Average(RNG)
End With
With MMax
.Value = WF.Max(RNG)
Set c = RNG.Find(.Value)
.Offset(1, 0) = c.Row - RNG.Row + 1
.Offset(2, 0) = c.Column - RNG.Column + 1
End With
With Mmin
.Value = WF.Min(RNG)
Set c = RNG.Find(.Value)
.Offset(1, 0) = c.Row - RNG.Row + 1
.Offset(2, 0) = c.Column - RNG.Column + 1
End With
With Suchzelle
.Offset(1, 0) = WF.CountIf(RNG, .Value)
.Offset(2, 0) = WF.CountIf(RNG, "
LG UweD