Calculate only Positive Numbers

[Guest]

I need to know if there is a way to calculate only cells within a column
(column AL) that are a positive number. The column has rows 3 through 1359
with quite a few that are negative numbers (these numbers are a result of a
formula) WE only want to include in the column total those numbers that have
a positive result. Is this possible? THanks

 

[Dav]

sumif(al3:al1359,">0",al3:al1359)

Regards

Dav

 

[Guest]

If you summing them:

=SUMIF(AL3:AL1359,">0")

HTH

 

[Franz Verga]

Nel post *B G* ha scritto:

I need to know if there is a way to calculate only cells within a
column (column AL) that are a positive number. The column has rows 3
through 1359 with quite a few that are negative numbers (these
numbers are a result of a formula) WE only want to include in the
column total those numbers that have a positive result. Is this
possible? THanks

=SUMIF(AL3:AL1359,">0")


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy