Forum Discussion
Bazzwano
Jan 23, 2024Copper Contributor
Formula that use cell string data
Hello, I have a bunch of tabs in a excel spreadsheet. These tabs are all labeled and the labels are also copied in cells.
In one of the tabs I am referring to the contents of other tabs by using:
=COUNTIF(Login!K:K, "Android Only")
The problem is I am starting to use this formula a lot and for all the tabs. Its becoming a lot of work to update these string each time I update a formula and drag it down.
I was hoping that I could replace [Login] with something that will just return the string from A2. I have tried a number of things from info online but I couldn't get anything to work.
Thank you in advance of any help
Cheers.
=COUNTIF(INDIRECT("'"&$A2&"'!K:K"), "Android Only")
=COUNTIF(INDIRECT("'"&$A2&"'!K:K"), "Android Only")
- BazzwanoCopper Contributor
HansVogelaar
That works thank you so much!