title: Adding up all the positive numbers in Excel
body: <p>Is there a way to add up all of the positive numbers in a row/column but ignoring all of the negative numbers?  Like SUM(), except that it ignores negative numbers.  Would I have to use VBA?  If so, how would I do it in VBA?</p>
  
  <p>If it can't be done in Excel, can it be done in OpenOffice Calc?</p>