SumIf Formula Addition Based On AlphaNumeric Criteria

[LalitPandey87]

Copy below formula and paste this in cell H1 with CSE
=SUM(IFERROR((INT($A$1:$A$32) >= 3001)*(INT($A$1:$A$32) <= 3007)*($E$1:$E$32),0))

Copy below formula and paste this in cell H3 with CSE
=SUM(IFERROR((RIGHT($A$1:$A$32,1)="D")*(--(SUBSTITUTE($A$1:$A$32,"D",""))>=3001)*N(--(SUBSTITUTE($A$1:$A$32,"D",""))<=3007),0)*$E$1:$E$ 32)

Copy below formula and paste this in cell H5 with CSE
=SUM(IFERROR((INT($A$1:$A$32) >= 3500)*(INT($A$1:$A$32) <= 3515)*($E$1:$E$32),0))

As all these are array formula so please apply it with Control + Shift + Enter