Forum Discussion

Bazzwano's avatar
Bazzwano
Copper Contributor
Jan 23, 2024

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. 

Resources