CBoukal
New Member
- Joined
- Oct 3, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
I read an old post on using indirect within a formula but it doesn't really work. I am trying to use the text of a cell within the formula below. B2 is a sheet name within the workbook. Rather than retyping the sheet name 60 times or using the search replace for Sheet, is there a way to make this work?
=COUNTIF(INDIRECT(B2)!$H$3:INDIRECT(B2)!$H$500, "Win")
=COUNTIF(INDIRECT(B2)!$H$3:INDIRECT(B2)!$H$500, "Win")