Spreadsheet: 46379d1245258042-summing-up-opposite-numbers-in-a-column-based-on-criteria-sample-file-rs-3-
Sheet: ORIGINAL DATA

Invoice Number | Amt Due Original | Applied Payments |  | Desired Result |  | YOUR FORMULA
102988 | 600 | 0
102988 | 0 | -354.1 |  | -354.1 |  | -354.1
103049 | 1000 | 0
103049 | 0
103676 | 1500 | 0
103676 | 0
103679 | 403.85 | 0
103679 | 0
103680 | 500 | 0
103680 | 0
105651 | 600 | 0
105651 | 0 | -480 |  | -480 |  | -480
106016 | 600 | 0
106016 | 0 | -480 |  | -480 |  | -480
106456 | 600 | 0
106456 | 0 | -480 |  | -480 |  | -480
106457 | 1500 | 0
106457 | 0
106459 | 1000 | 0
106459 | 0
106762 | 600 | 0
106762 | 0 | -480 |  | -480 |  | -480
106763 | 1500 | 0
106763 | 0
106765 | 1000 | 0
106765 | 0
107197 | 600 | 0
107197 | 0 | -480 |  | -480 |  | -480
107198 | 1500 | 0
107198 | 0
107200 | 1000 | 0
107200 | 0
CC-H02-107102737 | 5100 | 0
CC-H02-107102737 | 0
CC-H02-108044905 | 5100 | 0
CC-H02-108044905 | 0 | -2361.3 |  | -2361.3 |  | -2361.3
CC-H02-108096748 | 6375 | 0
CC-H02-108096748 | 0 | 6375
CC-H02-108096748 | 0 | -6375
CC-H02-108107192 | 4129.74 | 0
CC-H02-108107192 | 0 | -3429.75 |  | -3429.75 |  | -3429.75
CC-H02-108107372 | 11360.25 | 0
CC-H02-108107372 | 0
CC-H02-108107407 | 3612.5 | 0
CC-H02-108107407 | 0
CC-H02-108117569 | 3782.5 | 0
CC-H02-108117569 | 0
CC-H02-108117587 | 1265 | 0
CC-H02-108117587 | 0
CC-H02-108117633 | 2193 | 0
CC-H02-108117633 | 0
CC-H02-108117651 | 5015 | 0
CC-H02-108117651 | 0
CC-H02-108117678 | 9588 | 0
CC-H02-108117678 | 0
CC-H02-108117720 | 7484.25 | 0
CC-H02-108117720 | 0
CC-H02-108117738 | 7041.4 | 0
CC-H02-108117738 | 0
CC-H02-108117761 | 13940 | 0
CC-H02-108117761 | 0
CC-H02-108117777 | 7225 | 0
CC-H02-108117777 | 0 | 7225
CC-H02-108117777 | 0 | -7225
CC-H02-108117785 | 39737.5 | 0
CC-H02-108117785 | 0
CC-H02-108117800 | 8916.5 | 0
CC-H02-108117800 | 0
CC-H02-108127902 | 575 | 0
CC-H02-108127902 | 0
CC-H02-108128002 | 7100.9 | 0
CC-H02-108128002 | 0
CC-H02-108128006 | 7470 | 0
CC-H02-108128006 | 0
CC-H02-108128056 | 37782.5 | 0
CC-H02-108128056 | 0
CC-H02-108128066 | 2618 | 0
CC-H02-108128066 | 0
CC-H02-108128089 | 14935.75 | 0
CC-H02-108128089 | 0
CC-H02-109018177 | 38.25 | 0
CC-H02-109018177 | 0
CC-H02-109018210 | 6838.25 | 0
CC-H02-109018210 | 0 | -425 |  | -425 |  | -425
CC-H02-109018213 | 3187.5 | 0
CC-H02-109018213 | 0
CC-HO1-108105391 | 2698.75 | 0
CC-HO1-108105391 | 0 | -1620.3
CC-HO1-108105391 | 0 | -1620.3 |  | -1620.3 |  | -1620.3
CC-HO1-108105391 | 0 | 1620.3
CC-HO3-108053647 | 8925 | 0
CC-HO3-108053647 | 0 | -1500 |  | -1500 |  | -1500
CC-HO3-108084404 | 400 | 0
CC-HO3-108084404 | 0
CC-HO3-108094842 | 13098.5 | 0
CC-HO3-108094842 | 0 | -7181.25 |  | -7181.25 |  | -7181.25
CC-HO4-109016696 | 1730 | 0
CC-HO4-109016696 | 0 | -400 |  | -400 |  | -400
CC-HO4-109016696 | 0 | -445 |  | -445 |  | -445
CC-HO4-109016696 | 0 | -475 |  | -475 |  | -475
CC-HO4-109016733 | 400 | 0
CC-HO4-109016733 | 0 | -300 |  | -300 |  | -300
CC-HO4-109016782 | 1483.08 | 0
CC-HO4-109016782 | 0
CC-HO4-109026805 | 500 | 0
CC-HO4-109026805 | 0 | 500
CC-HO4-109026805 | 0 | -491 |  | -491 |  | -491
CC-HO4-109026805 | 0 | -500
CC-HO4-109026830 | 400 | 0
CC-HO4-109026830 | 0
CC-HO4-109026885 | 866 | 0
CC-HO4-109026885 | 0 | -300 |  | -300 |  | -300
CC-HO4-109026885 | 0 | -200 |  | -200 |  | -200
CC-HO4-109026885 | 0 | -300 |  | -300 |  | -300
CC-HO4-109026887 | 450 | 0
CC-HO4-109026887 | 0
CC-HO4-109026924 | 1002 | 0
CC-HO4-109026924 | 0 | -370 |  | -370 |  | -370
CC-HO4-109026924 | 0 | -600 |  | -600 |  | -600
CC-HO4-109026930 | 450 | 0 |  | .
CC-HO4-109026930 | 0
CC-HO4-109026961 | 361.25 | 0
CC-HO4-109026961 | 0
CC-HO4-109026984 | 1483.08 | 0
CC-HO4-109026984 | 0
CC-HO4-109026993 | 7320 | 0
CC-HO4-109026993 | 0
CC-HO5-108083887 | 374.99 | 0
CC-HO5-108083887 | 0
CC-HO5-108104287 | 212.5 | 0
CC-HO5-108104287 | 0 | -195 |  | -195 |  | -195
CC-HO5-108104321 | 2655 | 0
CC-HO5-108104321 | 0 | 445
CC-HO5-108104321 | 0 | 445
CC-HO5-108104321 | 0 | -445
CC-HO5-108104321 | 0 | -445
CC-HO5-108104321 | 0 | -1500 |  | -1500 |  | -1500
CC-HO5-108104321 | 0 | -680 |  | -680 |  | -680
CC-HO5-108125064 | 1819 | 0
CC-HO5-108125064 | 0 | 235.8
CC-HO5-108125064 | 0 | -235.8
CC-HO5-108125064 | 0 | -235.8 |  | -235.8 |  | -235.8
CC-HO5-108125064 | 0 | -425 |  | -425 |  | -425
CC-HO5-108125065 | 2758.25 | 0
CC-HO5-108125065 | 0
CC-HO5-108125071 | 16519.75 | 0
CC-HO5-108125071 | 0
CC-HO5-108125073 | 4335 | 0
CC-HO5-108125073 | 0
CC-HO5-108125080 | 4293.75 | 0
CC-HO5-108125080 | 0 | 4293.75
CC-HO5-108125080 | 0 | -4293.75
CC-HO5-108125102 | 2868.75 | 0
CC-HO5-108125102 | 0
CC-HO5-109015140 | 1776.5 | 0
CC-HO5-109015140 | 0
CC-HO5-109015202 | 2677.5 | 0
CC-HO5-109015202 | 0
CC-HO5-109015208 | 2262.5 | 0
CC-HO5-109015208 | 0
CC-HO5-109015258 | 765 | 0
CC-HO5-109015258 | 0
CC-HO5-109025304 | 1683 | 0
CC-HO5-109025304 | 0 | -1497.87 |  | -1497.87 |  | -1497.87
IN-H02-108065820 | 18513 | 0
IN-H02-108065820 | 0 | -1394.58 |  | -1394.58 |  | -1394.58
IN-H02-108065820 | 0 | -3513 |  | -3513 |  | -3513
IN-H02-108065820 | 0 | -5000 |  | -5000 |  | -5000
IN-H02-108065820 | 0 | -2139 |  | -2139 |  | -2139
IN-H02-108075966 | 8874 | 0
IN-H02-108075966 | 0
IN-H02-108086403 | 918 | 0
IN-H02-108086403 | 0 | 918
IN-H02-108086403 | 0 | -918
IN-H02-108086430 | 3115.25 | 0
IN-H02-108086430 | 0
IN-H02-108086431 | 6109.8 | 0
IN-H02-108086431 | 0 | -5292.8 |  | -5292.8 |  | -5292.8
IN-H02-108086431 | 0 | 817
IN-H02-108086431 | 0 | -400.65 |  | -400.65 |  | -400.65
IN-H02-108086431 | 0 | -817
IN-H02-108086434 | 918 | 0
IN-H02-108086434 | 0
IN-H02-108096731 | 918 | 0
IN-H02-108096731 | 0
IN-H02-108096759 | 6570 | 0
IN-H02-108096759 | 0 | -4299 |  | -4299 |  | -4299
IN-SJ3-108128184 | 2800 | 0
IN-SJ3-108128184 | 0 | 1590
IN-SJ3-108128184 | 0 | 1590
IN-SJ3-108128184 | 0 | 1590
IN-SJ3-108128184 | 0 | -1590
IN-SJ3-108128184 | 0 | -1590
IN-SJ3-108128184 | 0 | -1590
IN-SJ3-108128184 | 0 | -1590 |  | -1590 |  |  | Not being picked up.
IN-H02-108096814 | 600 | 0
IN-H02-108096814 | 0 | -200 |  | -200 |  | -200
IN-SJ3-108128185 | 2800 | 0
IN-SJ3-108128185 | 0 | 1590
IN-SJ3-108128185 | 0 | 1590
IN-SJ3-108128185 | 0 | 1590 |  | 1590 |  |  | Changed last digit of invoice number from 4 to 5 and tried with more positive amounts.
IN-SJ3-108128185 | 0 | -1590
IN-SJ3-108128185 | 0 | -1590
IN-H02-108096905 | 535.5 | 0
IN-H02-108096905 | 0
IN-MI1-107092709 | 6450 | 0
IN-MI1-107092709 | 0 | -1250 |  | -1250 |  | -1250
IN-MI1-107092709 | 0 | -1000
IN-MI1-107092709 | 0 | 1000
IN-MI1-107092709 | 0 | 1000
IN-MI1-107092709 | 0 | -1000
IN-MI1-107092709 | 0 | -1000 |  | -1000 |  |  | Same invoice number but the third amount is not being picked up.
IN-MI1-107092709 | 0 | -1000 |  | -1000 |  |  | Same invoice number but the second amount is not being picked up.
IN-H02-108097033 | 9046.55 | 0
IN-H02-108097033 | 0 | 9046.55
IN-H02-108097033 | 0 | 8330.85
IN-H02-108097033 | 0 | -8330.85
IN-H02-108097033 | 0 | -8330.85 |  | -8330.85 |  | -8330.85
IN-H02-108097033 | 0 | -9046.55
 | SUM | -61506.25 |  | -61506.25 |  | -59506.25
 |  |  |  |  |  | -2000 | [NAME]
 | 391652.89 | -123012.5