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") Thank...
This formula sums only positive numbers. If sum all as positive
=SUMPRODUCT(ABS(C2:C18145))
This formula sums only positive numbers. If sum all as positive
=SUMPRODUCT(ABS(C2:C18145))
You Rock! Thank you very much.