Forum Discussion
Solved
Adding negative numbers as though they are positive.
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!
This formula sums only positive numbers. If sum all as positive
=SUMPRODUCT(ABS(C2:C18145))
2 Replies
This formula sums only positive numbers. If sum all as positive
=SUMPRODUCT(ABS(C2:C18145))
- You Rock! Thank you very much.
