Hi Jan,

"Jan Kronsell" schrieb

=SUM((T(INDIRECT("'"&TRANSPOSE(A1:A36)&"'!A"&ROW(5 :20)))=D9)*(N(INDIRECT("'"&TRANSPOSE(A1:A36)&"'!Q" &ROW(5:20)))))
Both formulas are array formulas to insert with CTRL+Shift+Enter

I tried your formula but get a #NAME! error.

which version/language of Excel do you use?

--
Lisa