Adding negative numbers as though they are positive.

[KLT80]

I'm looking to add up all the consumption data in a column as though they are all positive numbers.

Someone gave me this formula but I believe it is inaccurate:

=SUMIF(C2:C18145,">=0")

Thanks!

[#2 · Accepted solution]

This formula sums only positive numbers. If sum all as positive

=SUMPRODUCT(ABS(C2:C18145))

[#3]

You Rock! Thank you very much.