SOLVED
Home

Adding negative numbers as though they are positive.

KLT80
New Contributor

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 Replies
Solution

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

=SUMPRODUCT(ABS(C2:C18145))

 

You Rock! Thank you very much.