I am trying to write a sumif statment that looks up a date. In my array the
criteria is showing up twice. How could i write a statement that would bring
back the answer from the closest date.