Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Formula that use cell string data

Copper Contributor

Hello, I have a bunch of tabs in a excel spreadsheet. These tabs are all labeled and the labels are also copied in cells.

 image.png

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. 

2 Replies
best response confirmed by Bazzwano (Copper Contributor)
Solution

@Bazzwano 

=COUNTIF(INDIRECT("'"&$A2&"'!K:K"), "Android Only")

@Hans Vogelaar 
That works thank you so much!

1 best response

Accepted Solutions
best response confirmed by Bazzwano (Copper Contributor)
Solution

@Bazzwano 

=COUNTIF(INDIRECT("'"&$A2&"'!K:K"), "Android Only")

View solution in original post