| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding only the negative or positive numers in a column or row
How do I add only the negative or only the positive numbers in a selected
range? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding only the negative or positive numers in a column or row
To sum negative numbers only in a selected range,
=SUMIF(range,"<0") To sum positive numbers only in a selected range, =SUMIF(range,"0") "slowes" wrote: How do I add only the negative or only the positive numbers in a selected range? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding only the negative or positive numers in a column or row
Hi,
In another cell put =SUMIF(range,"<0") to get the total of negative numbers and =SUMIF(range,"0") for the total of positive numbers. Regards, Jaleel "slowes" wrote: How do I add only the negative or only the positive numbers in a selected range? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Stacked column with negative values | Charts and Charting in Excel | |||
| Convert a column of numbers from positive to negative in Excel | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Linear Mode
