| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding only positive numbers
I have a column of $ amounts (some negative) for which I would like to write
a function to add ONLY the positive numbers, and exclude the negative ones. How can this be done. -Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding only positive numbers
Try this:
=SUMIF(A1:A10,"0") Biff "Eric" wrote in message ... I have a column of $ amounts (some negative) for which I would like to write a function to add ONLY the positive numbers, and exclude the negative ones. How can this be done. -Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding only positive numbers
hi,
look up sumif. it might look something like this... =sumif(c1:c10,"=0",c1:c10) regards FSt1 "Eric" wrote: I have a column of $ amounts (some negative) for which I would like to write a function to add ONLY the positive numbers, and exclude the negative ones. How can this be done. -Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numbers not adding together correctly | Excel Worksheet Functions | |||
| How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
| Displaying all numbers as positive | Excel Worksheet Functions | |||
| Adding to a column of numbers | Excel Worksheet Functions | |||
| Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
Hybrid Mode
