Need Formula Help
 

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

Need Formula Help
 

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

Need Formula Help
 

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

Need Formula Help
 

Your words and your example *don't* match!

Your example:
=5<8 (greater then *OR* equal to 5 and less then 8)
means you want to total matching rows to
5, 6, and 7

Your words:
<<<"greater than and less than the value of the item numbers"
means you want to total matching rows to
6 and 7

Whatever your intentions are, simply place those numbers within the curly
brackets.

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Mike" wrote in message
...
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