{=SUM(OFFSET($E$1,MATCH($A$2,$A$1:$A$213,0)-1,0,MATCH(0,IF($A$2:$A$213=$A$2,$E$2:$E$213),0)-MATCH($A$2,$A$1:$A$213,0)+1,1))}

This array formula (Press Ctrl + Shift + Enter) will give you the exact result which your formula in your original post was giving.