Add values of cells

B2 · Jun 11, 2004

I need to sum the values of a column of cells with both
positive and negative numbers, but I want to exclude the
negative numbers?

kkknie · Jun 11, 2004

Use:

=SUMIF(D2

5,">0")

With D2

5 replace by your range.

Frank Kabel · Jun 11, 2004

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