Adding positive and negative numbers
Hello,
I need a formula that multiplies two columns that may have a negative number(s). I need the negative numbers to be subtracted.
I was trying the following formula: =SUMPRODUCT(L93:L104*N93:N104)---however it was subtracted the negative number twice. For example if the total was 130 and then a -5 was put in... the result would be 120 instead of 125.
Can you give a sample of what is in L93:L104 and N93:N104... I don't see what you mean.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks