=SUMPRODUCT(((A1:A4="Duncan")+(A1:A4="Simplet"))*B 1:C4)

You were missing a parenthesis near the beginning.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bruce Benaway" wrote:

For some reason, I am having trouble getting this to work. Created the
following formula:

=SUMPRODUCT(('Incoming Cores'!A1:A4="Duncan")+('Incoming
Cores'!A1:A4="Simplet"))*'Incoming Cores'!B1:E4)

The actual spreadsheet covers a much larger area. Simply wanting the sum of
the Duncan and Simplet rows. Can anyone see what I have down wrong?


a b c
d e

1 smith 33 44 55
66
2 Duncan 45 56 45
38
3 Simplet 74 65 26
67
4 Duncan 6 78 67
69

--
Bruce