shuffleyourfeet
New Member
- Joined
- Apr 12, 2013
- Messages
- 6
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!
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!