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