Aladin Akyurek wrote...
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?

Interesting point. As I've written before, if there can be valid
positive and negative values, there can also be valid zero values. If
there can be valid zero values, you can't ignore all zeros in averages.

That said, if all the values were positive *and* there were only one
entry matching A1 in each other worksheets' A3:A30 range, then this
should work (at least it works in my tests).