Sub SYUUKEI()
Dim myROW As Long
Dim i As Long
With Worksheets("アンケート")
myROW = .Cells(Rows.Count, 2).End(xlUp).Row
Worksheets("集計").Range("C3:C7").Value = Empty
For i = 3 To myROW
If .Cells(i, 3).Value <= 6 Then '<---(1)
Worksheets("集計").Range("C3").Value = Worksheets("集計").Range("C3").Value + 1 '<---(2)
ElseIf (.Cells(i, 3).Value >= 7) And (.Cells(i, 3).Value <= 12) Then '<---(3)
Worksheets("集計").Range("C4").Value = Worksheets("集計").Range("C4").Value + 1 '<---(4)
ElseIf (.Cells(i, 3).Value >= 13) And (.Cells(i, 3).Value <= 15) Then '<---(5)
Worksheets("集計").Range("C5").Value = Worksheets("集計").Range("C5").Value + 1 '<---(6)
ElseIf (.Cells(i, 3).Value >= 16) And (.Cells(i, 3).Value <= 18) Then '<---(7)
Worksheets("集計").Range("C6").Value = Worksheets("集計").Range("C6").Value + 1 '<---(8)
ElseIf .Cells(i, 3).Value >= 19 Then '<---(9)
Worksheets("集計").Range("C7").Value = Worksheets("集計").Range("C7").Value + 1 '<---(10)
End If
Next i
End With
End Sub