Take a look at this simple range of values:

http://www.knot2worry.us/ff/Screen%20Shot

I am trying to write a formula that will total the values in the right
column for any item numbers between 5 and 8. This would probably be a SUMIF
formula (I suppose). The answer would of course be 145 but I cannot figure
out how to write the formula).

Thanks,
Mike