This is probably verry simple but i cant get my head around it.
If i want to sum A1+ A2 and A2 containes a negative number i only want to sum A1.
Like this:
Example 1
A1,A2
3,3
3+3 = 6 (Both cells contains positve number)
Exampel 2
A1, A2
5, -3 = 5 (A2 contains negative number only sum cell A1)
Best regards
Petter
Last edited by Petter120; 07-12-2014 at 08:38 AM.
should do what you need.Formula:
Please Login or Register to view this content.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
gak67's is shorter and to be preferred but just to show another technique
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If you were going with Richard's type of solution I'd shorten it slightly like this:Formula:Please Login or Register to view this content.
The formula doesn´t work so i changed the , to ; but i get a #name? error with that.
I attached an exampel:
The formula is in cell P1 and the the cells that i want to sum is K1 + M1
test.xlsx
It works for me. It opened with the error showing, but I double clicked on the cell and then pressed enter and it worked fine. P1 in the attached is my original formula and Q1 is my revised formula with Richard's methodology.
test (1).xlsx
I solved it, i have the swedish version so i had to change SUM to SUMMA so now it works fine, thank all verry much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks