Using =sumif to add up just the positive numbers and ignore minus???

[smerrick]

Hello,

I need to use formulas such as =sumif but was wondering if this could be amended so that when I add a column it will only take into account positive numbers and not the negatives? Failing that, would there be an alternative way to quickly do this?

Many Thanks

 

[smerrick]

old school - excel 2003!

 

[bebo021999]

old school - excel 2003!

Excel 2003 + not sumproduct => just use next column with this formula: If(cell>0,cell,0)
And use sumif(productcode,">0",Next column)