Steve Walton Wrote:[color=blue]
On Sat, 20 Nov 2004 11:33:36 -0600, Aladin Akyurek
wrote:


=SUMIF(B1:B3,"<",A1:A3)

or
{=SUM(IF(B1:B3"",A1:A3,0))}

to cover when b3=6
...



You seem to think that "a value" should be restricted to letters/text.
If so, you need something different than what you suggest for it fails
to exclude B3 = TRUE or include B3 housing a formula blank, etc.?


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319037