Try this:

=SUM(SUMIF(B:B,{5,6,7,8},D:D))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike" wrote in message
...
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