ExcelBanter - Negative values in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Negative values in a formula (https://www.excelbanter.com/excel-worksheet-functions/154999-negative-values-formula.html)

Susan

Negative values in a formula

How do you enter a formula to add the value of cells in a column, but minus
negative values in the column?

Susan

Toppers

Negative values in a formula

trY:

=SUMIF(A1:A50,"0")

"Susan" wrote:

How do you enter a formula to add the value of cells in a column, but minus
negative values in the column?

Susan

David Biddulph[_2_]

Negative values in a formula

Do you mean that when you add the numbers you want to treat the negative
numbers as zero, or that you want to treat them as positive (and take the
absolute value)?
--
David Biddulph

"Susan" wrote in message
...
How do you enter a formula to add the value of cells in a column, but
minus
negative values in the column?

Susan

All times are GMT +1. The time now is 12:31 PM.