Adding up all the positive numbers in Excel

excel sum openoffice.org worksheet-function
user192503 picture user192503 · Oct 20, 2009 · Viewed 12.3k times · Source

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?

If it can't be done in Excel, can it be done in OpenOffice Calc?

Answer

DaveParillo picture DaveParillo · Oct 20, 2009

Use SUMIF. YTo sum all the positive numbers in Column A:

=SUMIF(A:A,">0")

Same function exists in Excel and Calc

Related questions

Sum function in VBA

I have a problem with summing cells in vba. I need to use Cells(a,b): Range("A1").function="=SUM(Range(Cells(2,1),Cells(3,2)))" but it doesn't work.

Read More
How to SUM parts of a column which have same text value in different column in the same row

I have a column with names and a column with numbers: FirstName Name Number John Smith 17 John Smith 26 Peter Smith 116 Peter Smith 25 Franck Black 17 Luke Peterson 17 Luke Peterson 37 Names with same FirstName and Name represent the same person. I need …

Read More
Using SUMIFS with multiple AND OR conditions

I would like to create a succinct Excel formula that SUMS a column based on a set of AND conditions, plus a set of OR conditions. My Excel table contains the following data and I used defined names for the …

Read More