Hi all.
I have a column that contain positive and negative numbers. I would like to make a filter to get the final result which are greater the positive or negative for EX:
The column contain this numbers.
-15
20
-23
5
10
19
-22
-15+-23+-22 = -60
20+5+10+19 = 54
in this calculation the negative number is greater.
Try:
Formula:
=MAX(SUMIF(A1:A7,">0"),-SUMIF(A1:A7,"<"&0))
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Sorry The result it showing all positive number even if it negative
Thank you Olly for your help..
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.
Is this better?
=IF(SUM(A1:A7)<0,"-","+")&MAX(SUMIF(A1:A7,">0"),-SUMIF(A1:A7,"<"&0))
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
I think it need to be adjusted. because i add ( 10,-8,-18 ) and the results i got is -18 what it should give me the results as -8
Can you explain that logic? That's not consistent with your original requirement.Originally Posted by savio
Why should the result be -8, for the input array (10, -8, -18) ? The logic from your original post would sum the negative numbers, and give a result of -26.
=max(A1:A7)+min(A1:A7)
Sorry to say it still not working. it give the result as 0 for
10
-8
-10
Sorry. Yes it should show the result as -16, but it's not
why don't you simply sum the values?
=Sum(A1:A7)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks