Sum a range of absolute values

  • Thread starter lister_d_000169
  • Start date
L

lister_d_000169

I am looking to sum a range of cells but not include in the sum any
negative values.

Thus far all that i could think of doing was a round about way via the
ABS and the SUM functions but was looking to see if there was a
function that would do the whole job lot in one go!!
 
R

Ron Coderre

lister_d_000169

=SUMIF(A1:A100,">0")

That will sum only the positive numbers in Cells A1:A100

Does that help?

Regards,
Ron
 
L

lister_d_000169

Cheers Ron

i had toyed with the sumif but never put the " " round teh criteria

cheers !!
 
A

aidan.heritage

Whilst this will work, it does seem a little hard on the SUMIF function
which will do it with fewer keystrokes!!!
 
Top