I have 2 columns L and N that have payment dates in them, I need a formula
that will scan those 2 columsn because the payments are made in 2 equal
payments and add everything from another column into a cell made for that
date. adds everything together-sumif is working fine with only one column of
dates, but with 2 columns, some strange additions are happening. Any help is
appreciated.


Client Debt Amount Commission 2 Pymnts of: 1st Payment 2nd Payment
client1 27,133.92 542.68 271.34 1-Nov
client2 11,448.57 228.97 114.49 5-Nov
client3 15,678.30 313.57 156.78 15-Nov 15-Dec
client4 14,763.07 295.26 147.63 1-Dec
client5 31,546.65 630.93 315.47 1-Nov 15-Nov
client6 17,265.40 345.31 172.65 1-Dec 10-Dec
client7 21,889.56 437.79 218.90 15-Nov
client8 29,663.48 593.27 296.63 1-Dec
client9 26,174.25 523.49 261.74
client10 42,000.00 840.00 420.00
client11 25,546.80 510.94 255.47
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00