, Подсчет делается макросом по нажатию кнопки на листе "Необходимо"
Код
Sub test()
Dim dicTemp As Object
Set dicTemp = CreateObject("Scripting.Dictionary")
With Sheets(1)
lrow = .Cells(1, 1).End(xlDown).Row
For i = 2 To lrow
If .Cells(i, "G") >= Sheets(2).Range("B2") And .Cells(i, "G") <= Sheets(2).Range("B3") Then
arrFIO = Split(.Cells(i, "F"), "/")
For j = LBound(arrFIO) To UBound(arrFIO)
If dicTemp.Exists(arrFIO(j)) = False Then
dicTemp.Add arrFIO(j), Split(.Cells(i, "D"), "/")(j)
Else
dicTemp.Item(arrFIO(j)) = --dicTemp.Item(arrFIO(j)) + --Split(.Cells(i, "D"), "/")(j)
End If
Next j
End If
Next i
End With
Sheets(2).Range("A5").Resize(dicTemp.Count, 1) = WorksheetFunction.Transpose(dicTemp.Keys)
Sheets(2).Range("B5").Resize(dicTemp.Count, 1) = WorksheetFunction.Transpose(dicTemp.Items)
End Sub