Den søndag den 5. oktober 2014 17.36.15 UTC+2 skrev Lisa Wilke-Thissen:
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

2007

Jan