Sumproduct query
sorry, i meant count... either way, it still seems to be returning an N/A
error. Is the rest written correctly?
"Barb Reinhardt" wrote:
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.
|