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.
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies