Feb 05 2019 09:03 AM
So essentially what I am trying to set up, is something for my robotics team, what I am struggling to do is essentially make it so if A2 says, for example, The Cheesy Poof, it would go to the corresponding tab called The Cheesy Poof, and then pull data from that tab and run it through that function (so average, or countif, etc) . Each different row would run different data from different Tabs, based upon what Column A Row X says.
Here, an example spreadsheet to show what I am trying to do:
Thank you so much!
Feb 06 2019 06:48 AM
SolutionHi,
I have create a extra column where the extra characters are aded to make it possible to use a INDIRECT formula to use in your COUNTIF.
See attached
Feb 06 2019 06:48 AM
SolutionHi,
I have create a extra column where the extra characters are aded to make it possible to use a INDIRECT formula to use in your COUNTIF.
See attached