You are counting the number of matches with this. Remove the -- to sum the
matches.

"shakey1181" wrote:

I'm using the below formula, to sum data from a specific range that meets my
specific criteria. I think there must be a mistake in how it is written, but
i can't figure it out.

=SUMPRODUCT(--('\\office1\shared\[Test1.xls]Sheet1'!E$11:E$20={11;12;13;15;17;18;19;20;32;33;3 4;52;69;82;83;85;86;87}))

much obliged for any assistance on this.