| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing only positive or negative values
I have a list of values, some of which are positive and some are negative. I
want to sum all positive values in the list, and all negative values in the list. Is anyone aware of a function that allows me to do this? Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing only positive or negative values
You want the SUMIF function.
For positive values: =SUMIF(A1:A10,"0") For negative values: =SUMIF(A1:A10,"<0") -- Rick (MVP - Excel) "Daniel Collison" wrote in message ... I have a list of values, some of which are positive and some are negative. I want to sum all positive values in the list, and all negative values in the list. Is anyone aware of a function that allows me to do this? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Negative with Positive Values | Excel Discussion (Misc queries) | |||
| summing positive values (cells) in excel | Excel Worksheet Functions | |||
| Changing positive values to negative | New Users to Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| ... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
Linear Mode
