INDIRECT in SUMPRODUCT for sheets with different name

[shuffleyourfeet]

Hello,

I work on four sheets on excel with the same layout. Each sheet contains two columns, A: users and B: country of origin. I created these 4 sheets in order to categorize the users according to role (eg: Musicians, Public, Music Sites etc).

I also created a 5th sheet to do my analytics. For example I wanted to count how many people, of all the users, came from Germany. Therefore i used an indirect formula to import data from all 4 sheets. This formula was:

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&{1,2,3,4}&"!B1:B40"),"germany"))

It worked. Now, in order to make it more presentable I renamed the sheets according to role. So now

Sheet1=Musicians
Sheet2=Public

and so on. Which formula should I use in order to get the same results after this alteration?
The abovementioned formula doesn't work. I tried different combinations but still got errors. Any suggestions?

Thanks!

 

[shuffleyourfeet]

Yeah, that is correct. It didn't let me type the criteria in the dialogue box, that's where I got confused.
Thanks a lot mate!