dsum and another formula

[dkarasek]

Mr. Excel,

I am working on a project using multiple dsums to take confusing, mulitple accounts and putting them into useful titles. However, because there are accounts that are added throughout the year, I want to have another formula that takes all of the accounts that I already accounted for in the dsums, and subtract it from the final total sum. However, the twist is that there are multiple accounts that have a debit and a credit (meaning they cancel each other out). For the other formula, I am having trouble taking into account this twist. I need a formula that will take into account this twist and still will take the difference between the final total and the rest of the dsums.
Can you help?
Thanks,
Doug

 

[rmtimmah]

dkarasek,

try posting some example data. Your explanation is not exactly clear. See this post http://www.mrexcel.com/forum/showthread.php?t=89356

 

[dkarasek]

Here is a small example
This is my database...

Jon 4 5 6 7 8 9
Jake 3 4 3 3 4 3
Jim 4 3 2 3 2 2
Total #1 11 12 11 13 14 14
Jake -3 -4 -3 -3 -4 -3
Total#2 -3 -4 -3 -3 -4 -3

Here is what I want it to return
Jon dsum jon's info for each column
Jake dsum jake for each column (but it cancels out)
Jim *need a formula to return jims number without using dsum. need to take the total #1 and subtract it from jon and jake's number. The problem is that jake's dsum cancels out and I don't know a formula/way to return just jim's number because Jake's cancels out.
Total sum of jon jake and jim's numbers