Hello there,
so this is what I am trying to do
I have this huge data set by columns Q.1, Q.2, etc.
I defined the name ranges so that all data from one column can be refered by its header
so now I am creating some graphs using name ranges, and I would like to change the name range refered in all cells of the graph easily, for example changing one cell where the range name is written.
to create the data for the graph I am using the COUNTIF funcion, and I have to enter the range as the first agrument -- however if select the cell where the name range is written it does not take it as such and just counts the appreances on that very same cell. I also tried to put that text in the formula using CONCATENATE (and concatenating with nothing else), but it does not work either.
Is there any workaround for what I am trying to do?
thanks in advance
Bernat
Bookmarks