SumIf Formula Addition Based On AlphaNumeric Criteria

[Howardc]

I have account numbers in Col A and values in Col E

I would like to add the data as follows

1) Range Col A 3001 to 3007 based on values in Col E
2) Range Col A 3001D to 3007D dased on values in Col E
3) Range Col A 3001K to 3007K dased on values in Col E
4) Range Col A 3500 to 3525 dased on values in Col E
5) Range Col A 4000 to 4007 dased on values in Col E
6) Range Col A 4000A to 4007A dased on values in Col E etc

I have attached sample data

Your assistance in this regard is most appreciated