Sumif of a range i.e between account codes 100 - 500

You're welcome. Don't forget to mark your thread as Solved (click on Forum Rules @ top of page and see instructions in rule #9).

And you should click on the small star icon at the bottom left corner of Jeff's post to thank him.