change in sum product formula

[cu525]

at present i am using this formula to pull in a total ammout of results into a summary cell
=SUMPRODUCT(--('2009 Pipeline'!$K$4:$K$64=Summary!$C$27),--('2009 Pipeline'!$M$4:$M$64=$B$29),--('2009 Pipeline'!$A$4:$A$64=Summary!$A30)*('2009 Pipeline'!$J$4:$J$64))

at present i have the referance cell at c27 which is 100% what i want to do is either change the ref cell to a choice of 4 diffrent cell for exaample
if any of the values are used 25%,50%,75% and 90% (so they are all added up)

hope this makes sence

Thanks

[mdbct]

If your percentages are in a continuous range you could use:

('2009 Pipeline'!$K$4:$K$64=Summary!$C$27:$C$30)

if the values are in a non continuous range you have to supply the values in an array within the formula.

('2009 Pipeline'!$K$4:$K$64={.25,.5,.75,.9})

[daddylonglegs]

If the values are in C27:C30 as mdbct suggests then you could use this form

=SUMPRODUCT(--ISNUMBER(MATCH('2009 Pipeline'!$K$4:$K$64,Summary!$C$27:$C$30,0)),--('2009 Pipeline'!$M$4:$M$64=$B$29),--('2009 Pipeline'!$A$4:$A$64=Summary!$A30),'2009 Pipeline'!$J$4:$J$64)