Lookup values accross several sheets to create summary sheet

**Absed** · 07-17-2012, 01:40 AM

That's not exactly what I was looking for but close to my another problem. I attached a sample workbook to this message where I tried to explain my questions more clearly.

**micope21** · 07-17-2012, 03:22 AM

Originally Posted by Absed

That's not exactly what I was looking for but close to my another problem. I attached a sample workbook to this message where I tried to explain my questions more clearly.

Ok. This formula =IF($A2="","",SUMPRODUCT(COUNTIF(INDIRECT("'"&Sheetlist&"'!A:A"),A2))) is correct.

I notice player10 name 5 different teams in season1 and 5 in season2. Do they allow same player name play in different teams per season? or just 1 player name per season?

If Yes? This formula I give you is correct.
If no? Try different formula.

Let me know

Cheer