Ragdyer,

Thanks for your help and reply. Actually, I did a poor job of stating my
objectives. Actually, what I want is a forumla that will provide the sum of
the values for items greater than and less than the value of the item
numbers. In other words, the sum of the values in the right column for item
numbers =5<8.

Can someone help?

"Ragdyer" wrote:

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