In column M I need to do count of three cells in the range B2K7. The range B1K1 - numbers of columns, where 1 is number for column B, 2 - for column C, etc. The range O2Q2 - numbers of columns I need to count.
I would like to automate it in the following way: when I put numbers of columns in range O2Q2 then in column M matching column letters will be counted.
Also O2Q2 numbers could be in one cell separated by comma.
Thanks.
I would like to automate it in the following way: when I put numbers of columns in range O2Q2 then in column M matching column letters will be counted.
Also O2Q2 numbers could be in one cell separated by comma.
Thanks.