Try this:

=SUMIF(List,"0",List)

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Vinayak Bhat" wrote:

I want to sum the positive values in a range.

I named the range and tried as follows but it doesnot work. Please advise.

=sum(if (list0,list,0))

Vinayak