How to exclude current column in COUNTIFS and similar functions in Numbers?

Hello dear community,

As per subject line, I'm using COUNTIFS quite extensively in a table and I would like to avoid the column the function lies on, to be counted in.

I've tried with the COLUMN() function but this wouldn't be accepted on a range of values such as in the following wrong example where I'm trying to use regular expressions:

COUNTIFS(... COLUMN($1:$1:);REGEX("^(?!"&COLUMN()&"$)") ...)

I surmise there must be an easy and elegant way to avoid the current column/row be taken into account in the COUNTIFS and similar functions. Would you know how?

Thank you so much in advance!

[Re-Titled by Moderator]