SumIf Formula Addition Based On AlphaNumeric Criteria

[Howardc]

thanks for the reply. Have attached example showiing the range of account numbers in Col G and then using the sum function to show the desired result in Col H

What I am trying to do is to have range of values added in Col E based on a range of account numbers in Col A

Hope this example makes it clearer of what I want to achieve