ExcelBanter - sum function

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

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

- - sum function (https://www.excelbanter.com/excel-worksheet-functions/234894-sum-function.html)

dannyboy8

sum function

I have a row of numbers, both positive and negative and am looking to sum up
these rows, but omit all the negative #s in the sum, how would I write a
formula for this?

Rick Rothstein

sum function

Change the range to suit your actual setup...

=SUMIF(A1:Z1,"0")

--
Rick (MVP - Excel)

"dannyboy8" wrote in message
...
I have a row of numbers, both positive and negative and am looking to sum
up
these rows, but omit all the negative #s in the sum, how would I write a
formula for this?

All times are GMT +1. The time now is 08:21 PM.