Feb 07 2019 12:33 PM
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!
Feb 07 2019 12:53 PM
SolutionThis formula sums only positive numbers. If sum all as positive
=SUMPRODUCT(ABS(C2:C18145))
Feb 07 2019 02:40 PM
Feb 07 2019 12:53 PM
SolutionThis formula sums only positive numbers. If sum all as positive
=SUMPRODUCT(ABS(C2:C18145))