Calculate only Positive Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Back
Top