| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Negative numbers
Hi
I am trying to add only the negative numbers in a row of cells from sheet 1 and have the results shown in a single cell on sheet 3, but I keep only getting the result of zero how would I correct this. The formula I am using in the cell on sheet three is: =SUMIF(Sheet1!B23:H23,"<0") Any help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
Threaded Mode
