Hello, I am trying to find the value in a series of cash flows that is
the first month to have a cash flow. I have the formula to find the
max, which is =SUMPRODUCT((MAX(($a2:$z20)*($a$1:$z$1)))), (thank you
Rick Rothstein!)where row 2 equals the cash flow and row 1 equals the
corresponding date.

I am now looking to find the first month with a number that is not
zero. I tried switching the MAX to MIN and the switching the sign
around. All I get is 0 when I do that. Any suggestions? Thanks again.

Dan