Sumproduct Formula To Sum Range With Criteria On Numeric Text

[Howardc]

Thanks, it works perfectly

The formula see C29 Sheet Account classification works perfectly

However, when I change increase the range from 1000 to say 3000 , it give me zero as the result

=SUM(IFERROR((INT(Sheet1!$C$5:$C$1000) >= 3000)*(INT(Sheet1!$C$5:$C$1000) <= 3015)*(Sheet1!$E$5:$E$1000),0))

When trying to add the range 3000D to 3015D, it gives me #value! see cell C32 sheet account classification"

It would be appreciated if you could assist