Excel query/macro , delete records where the aggregate value is not over 100

I have a spreadsheet with about 5000 records. I need to delete out the records where the Amount column is less than $10.00 unless the aggregate of the amount column is greater than or equal to $100. I have an ID column that matches to the name on the record. So is it possible to create something that for each ID number in the ID column if the Amount column is less than $10 delete it unless the same ID appears again and is greater than $100? TIA

Thanks, I ran this but I don't think it deleted the single records that were less than $10.

ok sorry, after I ran the macro I still have records that are still in the worksheet that are less than $10 but don't add up to atleast $100. I modified it so for my column W is the ID of the person and AH2 is the cost. Maybe I did this part wrong?

Sub DELSOME()

For i = Range("W" & Rows.Count).End(xlUp).Row To 2 Step -1

If Cells(i, 2) < 10 Then

If WorksheetFunction.SumIf(Range("W2:W4979"), Cells(i, 1), Range("AH2:AH4979")) < 100 Then

Cells(i, 1).EntireRow.Delete

End If
End If
Next

End Sub

Thank you very much!