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?
|