Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make negative numbers equal zero
I have a sheet set up with formulas, and i need a coloumn to sum up with only
the positive number in it. example, i need: 4+6+-2+2 to equal 12 any sugestions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make negative numbers equal zero
I would create a helper column which tests each value to insure that it is
positive, and, if not, sets a new value of zero and then sum that column. Example: =IF(A2<0,0,A2) and fill down (say in column B) Then sum column B. Dave -- Brevity is the soul of wit. "benny1" wrote: I have a sheet set up with formulas, and i need a coloumn to sum up with only the positive number in it. example, i need: 4+6+-2+2 to equal 12 any sugestions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make negative numbers equal zero
For this example, I'll assume your data is in A1:A4.
=SUMIF(A1:A4,"0",A1:A4) Adjust the range to meet your needs. HTH, Elkar "benny1" wrote: I have a sheet set up with formulas, and i need a coloumn to sum up with only the positive number in it. example, i need: 4+6+-2+2 to equal 12 any sugestions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
negative numbers | Excel Discussion (Misc queries) | |||
Converting positive numbers to negative numbers | Excel Worksheet Functions | |||
Displaying negative numbers - inconsistent between desktop and lap | Excel Discussion (Misc queries) | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel |