Do you have negative numbers in the ranges of interest?

No negatives.

The second Sumproduct is only counting a single instance where the value is
0 per sheet:

Sheet2

Sue....... 34
Joe........ 34
Bob....... 93
Jim........ 26
Joe....... 100
Tom...... 82

Sheet3

Tom....... 7
Sue........ 9
Liz........ 88
Joe........ 0
Joe....... 93
Bob...... 66

=SUMPRODUCT(--(SUMIF(INDIRECT("'"&wsl&"'!A4:A30"),A4,INDIRECT("' "&wsl&"'!D4:D30"))0))

Returns 2

Biff

"Aladin Akyurek" wrote in message
...
D

Biff wrote:
That doesn't work for me.

SUMPRODUCT(--(SUMIF(INDIRECT("'"&WSL&"'!A4:A30"),A4,INDIRECT("' "&WSL&"'!D4:D30"))0))

Returns the incorrect count

[...]

Do you have negative numbers in the ranges of interest?