"Peter" wrote in message
...
I have never used this with the * sign howeverif you find that
"=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C1 0))" does not work you
can
try another combination of the sae i.e.

=SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),--(C1:C10))

The * operator and the -- double unary behave in the same way (see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation), but in both cases the operator is not needed before the
straight array, only before the conditional tests

=SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),C1:C10)

this works fine, you can also substitute the "--" with 'SumProduct' each
time

This sounds very wrong to me, do you mean

=SUMPRODUCT(--(A1:A10="FSI"))+SUMPRODUCT(--(B1:B10="disk"))+SUMPRODUCT(--(C1
:C10))

because that is just meaningless to me, it gives a result, but nothing near
the correct result.