Convert text to range

Hi,

I want to refer the text content of a cell in another formula where the text content as defined as range.

Example

As referred in the attached file cell “I10” (totalmay) is referred in cell in “L10” (=COUNTIF(I10,(CONCATENATE($K10,L$3,"y")))

Also, the content of “I10” is also defined as range


Now I would like system to refer the contents of “I10” and take the corresponding range execute the command in cell “L10”


Hope this is clear, if not please write back


Regards
Sagar

You need the INDIRECT function. Try this formula in L10

=COUNTIF(INDIRECT(I10),$K10&L$3&"y")

or you can do without I10 and just reference I8

=COUNTIF(INDIRECT("total"&I8),$K10&L$3&"y")

Thanks a lot

Regards
Vimalakar