Trouble with formula

[Bruce Benaway]

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

 

[Luke M]

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

You were missing a parenthesis near the beginning.

 

[Bruce Benaway]

Thanks much, it worked. Have a general question as this has happened to me
before. How do you know when one, two or three parenthesis are needed before
and after some of these formulas. Thanks again.