summing positive values (cells) in excel

[Guest]

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 (list>0,list,0))

Vinayak

 

[Guest]

Try this:

=SUMIF(List,">0",List)

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

XL2003, WinXP

 

[Ragdyer]

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")