Min Sumproduct formula returns a zero.
 

I have a spreadsheet. Which can be viewed on my public box link
http://www.box.net/shared/movk8u3cws
My headings are A3 Date, B3 Name, C3 Contribution E3 12/08/07
Date=A3 Name=B3 Contribution=C3 12/8/2007=E3 Andy=F3
12/8/2007 Andy 1
12/8/2007 Andy 40
12/8/2007 Andy 3
12/8/2007 Andy 4

Date=A11 Name=B11 Contribution=C11 12/8/2007=E11 Andy=F11
12/8/2007 Andy 1
12/8/2007 Andy 40
12/7/2007 Andy 3
12/8/2007 Andy 4



In E3, I entered 12/08/07 and in F3 I entered Andy. I want my formula in J11
which is =SUMPRODUCT(MIN((B6:B9=F5)*(C6:C9=G5)*(D6:D9))) to return the
minimum contribution that Andy made on 12/08/07. When I substitute Min for
Max, the formula works with no problems at all. As soon as I switch to Min
the formula returns a zero. It will work if all the dates and all the names
are the same. But as soon as the Date or Name changes I get a zero fpr the
Min formula. I even entered it as an array but it won't work.

Min Sumproduct formula returns a zero.
 

change the star (multiply) to a comma (condition)

=SUMPRODUCT(MIN((B12:B15=F11),(C12:C15=G11)*(D12:D 15)))


Regards
Peter

"checkQ" wrote:

I have a spreadsheet. Which can be viewed on my public box link
http://www.box.net/shared/movk8u3cws
My headings are A3 Date, B3 Name, C3 Contribution E3 12/08/07
Date=A3 Name=B3 Contribution=C3 12/8/2007=E3 Andy=F3
12/8/2007 Andy 1
12/8/2007 Andy 40
12/8/2007 Andy 3
12/8/2007 Andy 4

Date=A11 Name=B11 Contribution=C11 12/8/2007=E11 Andy=F11
12/8/2007 Andy 1
12/8/2007 Andy 40
12/7/2007 Andy 3
12/8/2007 Andy 4



In E3, I entered 12/08/07 and in F3 I entered Andy. I want my formula in J11
which is =SUMPRODUCT(MIN((B6:B9=F5)*(C6:C9=G5)*(D6:D9))) to return the
minimum contribution that Andy made on 12/08/07. When I substitute Min for
Max, the formula works with no problems at all. As soon as I switch to Min
the formula returns a zero. It will work if all the dates and all the names
are the same. But as soon as the Date or Name changes I get a zero fpr the
Min formula. I even entered it as an array but it won't work.

Min Sumproduct formula returns a zero.
 

Thank you Billy! That did the trick.