Returning text string for column function or similar

Hi all,

I am working with formulas similar to this:

=COUNTIF(L$35:INDIRECT("L"&$B$1),"Error")

However, i want the "L" to change when I copy and past to a new colum, so that it changes in the same way that the L$35 ref does.

One way of doing this is to put a cell reference instead of "L" - so I'd need that cell to return the text of the column it is in. (unless this can all be done more simply).

Thanks in advance for your help

Hi, maybe

=COUNTIF(L$35:INDIRECT(LEFT(ADDRESS(1,COLUMN(L1),4)&$B$1),"Error")

Copying to right L becomes M, N...


Regards

Thanks very much!