Identify numbers that net to zero in column

[Darryproduct]

I'm trying to reconcile accounts that have multiple transactions that net to zero. Often there can be 1-4 numbers in the credit column that equal 1-4 numbers in the debit column. Is there a formula or can I utilize solver to help identify all the numbers that net to 0?

Transaction Date	Journal #	Debit	Credit	Difference
4/3/19	63564		-127.41	-127.41
4/9/19	63803		-984.82	-984.82
4/9/19	63804		-3771.17	-3771.17
4/9/19	63747	99.50		99.50
4/9/19	63747	3933.48		3933.48
4/9/19	63747		-314.10	-314.10
4/9/19	63747		-104.40	-104.40
4/9/19	63747	1,199.42		1,199.42
4/29/19	64182	91.20		91.20
			SUM	-$36.21

<tbody>
</tbody>

I'm trying to identify which numbers are creating the discrepancy of ($36.21) when it should be $0.

 

[GR00007]

How are you determining what values are to sum to zero - by account#, journal#?
The current sample given sums to a difference of 21.70.
Here's a formula to sum by a value: Journal #

Transaction Date	Journal #	Debit	Credit	Journal Sum
4/3/2019	63564	0	-127.41	-127.41
4/9/2019	63803	0	-984.82	-984.82
4/9/2019	63804	0	-3771.2	-3771.17
4/9/2019	63747	99.5	0	4813.9
4/9/2019	63747	3933.48	0	4813.9
4/9/2019	63747	0	-314.1	4813.9
4/9/2019	63747	0	-104.4	4813.9
4/9/2019	63747	1,199.42	0	4813.9
4/29/2019	64182	91.2	0	91.2

<tbody>
</tbody>

The formula in column E is:

=SUMIFS(C$2:C$10,B$2:B$10,B10)+SUMIFS(D$2:D$10,B$2:B$10,B10)

 

[Darryproduct]

How are you determining what values are to sum to zero - by account#, journal#?
The current sample given sums to a difference of 21.70.
Here's a formula to sum by a value: Journal #

Transaction Date	Journal #	Debit	Credit	Journal Sum
4/3/2019	63564	0	-127.41	-127.41
4/9/2019	63803	0	-984.82	-984.82
4/9/2019	63804	0	-3771.2	-3771.17
4/9/2019	63747	99.5	0	4813.9
4/9/2019	63747	3933.48	0	4813.9
4/9/2019	63747	0	-314.1	4813.9
4/9/2019	63747	0	-104.4	4813.9
4/9/2019	63747	1,199.42	0	4813.9
4/29/2019	64182	91.2	0	91.2

<tbody>
</tbody>

The formula in column E is:

=SUMIFS(C$2:C$10,B$2:B$10,B10)+SUMIFS(D$2:D$10,B$2:B$10,B10)

Sorry I wasn't specific enough. The "Difference" column is the sum of C and D. All credits are shown with a negative balance while a debit is a positive. The sum of the "Difference" column is -$36.21. I'm trying to identify which rows net to 0 and which rows net to the -$36.21 Difference.

I tried the formula but it doesn't seem to do this...if it does maybe I'm missing something.

 

[philwojo]

The Sum of your Difference column is not -$36.21, but rather it is $21.67 (positive). So you have more debits than credits.

How did you get to the -$36.21 value, I'm not following that part.
If you sum up the Debit column I get $5323.60
If you sum up the Creidts column I get -$5310.93, that is a difference of $21.67.

Also, to GR00007's point how are you trying to match these up. None of the debits exactly matches any of the Credits, so there is no one-to-one ratio to try and find out which one's don't match, at least not without more information to give us some sort of correlation.

 

[GR00007]

Note: 91.2 + (-127.41) does equal $-36.21, but how in the world are the first and last rows of the sample data related?