wie kann ich folgendes Problem lösen ?
1 A B C D E
2 Name1 Name2 Name3 U
3 U 0,5U 0,5U 2U
In Spalte E2 soll die Summe der U's erscheinen, U entspricht 1U!
1 A B C D E
2 Name1 Name2 Name3 U
3 U 0,5U 0,5U 2U
Function ZAEHLE_U(Bereich As Range) As String
Dim c As Range
Dim anz As Double
For Each c In Bereich
If c.Text = "U" Then
anz = anz + 1
ElseIf Len(c.Text) > 1 Then
anz = anz + CDbl(Left(c.Text, Len(c.Text) - 1))
End If
Next c
ZAEHLE_U = CStr(anz & "U")
End Function
Function ZAEHLE_FB(Bereich As Range) As String
Dim c As Range
Dim anz As Double
For Each c In Bereich
If c.Text = "FB" Then
anz = anz + 1
ElseIf Len(c.Text) > 2 Then
anz = anz + CDbl(Left(c.Text, Len(c.Text) - 2))
End If
Next c
ZAEHLE_FB = CStr(anz & "FB")
End Function