Didn't you happen to notice that the data returned from your formula in E4
was displayed left justified.
That should have given you a hint, since the other numbers would have been
right justified, MEANING ... that the returns from the E4 formula were
*Text*!
They are text because you placed quotes (" ") around the "numbers" in the
formula.
The Sum() function *doesn't* sum text.
Easy fix.
Remove the quotes!
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PaulStroik" wrote
in message ...
Yes, the formula in E4 does work. Here it is. I have the cell formatted
as 'General'.
=IF((D5<1),"0",IF((D5=1),"40",IF((D5<7),"80",IF((D 5<12),"120",IF((D5<20),
"160",IF((D520), "200"))))))
Thank you both for your prompt response. I am enjoying the challenge of
figuring this out but need closure before frustration sets in.
And Greetings - New Zealand - from WI, USA
--
PaulStroik
------------------------------------------------------------------------
PaulStroik's Profile:
http://www.excelforum.com/member.php...o&userid=24640
View this thread: http://www.excelforum.com/showthread...hreadid=382343