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

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

Your original formula *will* work, but ... since it's an *array* formula,
you'll need to enter it using CSE.

Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
You *must also* use CSE when revising the formula.

Since an array formula is not really necessary, you could simply use:

=SUMIF(list,"0")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Vinayak Bhat" wrote in message
...
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