First, you still can't use wild cards this way:

=SUMPRODUCT((C3:$C$3000="I*")*(F3:$F$3000=F2)*(E3: $E$3000))

Second...

Do you have any #value! errors in any of those ranges? If so, clean up those
errors.

Do you have any non-numeric data in E3:E3000?

If you have text in column E, then the syntax you used (multiplying the
true/falses by text) will fail.

You could try:

=SUMPRODUCT(--(LEFT(C11:$C$65536,1)="I"),--(F3:$F$3000=F2),(E3:$E$3000))

Adjust the ranges to match--but you can't use whole columns (except in xl2007).

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

Excel Nut wrote:

<<snipped
- Show quoted text -

=SUMPRODUCT((C3:$C$3000="I*")*(F3:$F$3000=F2)*(E3: $E$3000))

I have adjusted the formula so that it doesn't refer to ALL rows.
Currently my data goes down only to row 1541 but I need to reference
some extra rows below my current data to allow for additional data to
be added in the future. But when the SUMPRODUCT formula refers to
these empty rows it returns a #VALUE! error.

Any way around that?

--

Dave Peterson