louisjeorge75
Board Regular
- Joined
- Dec 1, 2006
- Messages
- 128
hi ,
i need to refer a sheet name which is in cell a1 to a formula
eg.
countif(sheet1!$a:$a,"y") instead of this can i refer cell a1 which has sheet1 in the formula as below countif(a1!$a:$a,"y")
i need to refer a sheet name which is in cell a1 to a formula
eg.
countif(sheet1!$a:$a,"y") instead of this can i refer cell a1 which has sheet1 in the formula as below countif(a1!$a:$a,"y")