Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ignore negative values when adding
When adding a column containing both negative and positive values, I only
want to add the positive values,and ignore the negative values how do I do this please? |
#2
|
|||
|
|||
ignore negative values when adding
Hi!
Try this: =SUMIF(A1:A10,"0") Biff "Eqa" wrote in message ... When adding a column containing both negative and positive values, I only want to add the positive values,and ignore the negative values how do I do this please? |
#3
|
|||
|
|||
ignore negative values when adding
I have past and present dates in column A and Dollar values positive and
negative in col B I want to sum Dollar values that are positive only and are older than todays date. How do I do this pls. "Biff" wrote: Hi! Try this: =SUMIF(A1:A10,"0") Biff "Eqa" wrote in message ... When adding a column containing both negative and positive values, I only want to add the positive values,and ignore the negative values how do I do this please? |
#4
|
|||
|
|||
ignore negative values when adding
See response in other thread.
-- HTH RP (remove nothere from the email address if mailing direct) "Eqa" wrote in message ... I have past and present dates in column A and Dollar values positive and negative in col B I want to sum Dollar values that are positive only and are older than todays date. How do I do this pls. "Biff" wrote: Hi! Try this: =SUMIF(A1:A10,"0") Biff "Eqa" wrote in message ... When adding a column containing both negative and positive values, I only want to add the positive values,and ignore the negative values how do I do this please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ignore zero values when plotting a graph | Charts and Charting in Excel | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Adding large minute and second values | Excel Worksheet Functions | |||
Adding values from previous worksheets | Excel Worksheet Functions | |||
Getting Count field to recognise rows with negative values in Exc. | Excel Worksheet Functions |