@column alternative / is there an @column function?

Will Hughes

Hi everyone,

I've created a formula that I'd like to replicate over many columns. I know I can paste it and change the column number, but is there a way to instruct the formula use a numbered row (in this case, 20) and the current column? Something like @column

=COUNTIFS({April/May 2021 Boot Raw Data Range 1}, [Primary Column]@row, {April/May 2021 Boot Raw Data Range 2}, "Yes", {April/May 2021 Boot Raw Data Range 3}, =[Column3]20)

Thanks for your time,

Will

Paul Newcome

If you dragfill, the column in bold should automatically update.