Not sure what your formula / criteria is but perhaps you could add a Max or
Min to it.

"graham" wrote:

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.