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 |