Hey guys,

is there a way to make the following equation

"=COUNTIF(B:B,"">"" & " & Selection.Value & ")+ COUNTIF(D:D,"">"" & " & Selection.Value & ")"

into a single COUNTIF() that moves the column over automatically.

OR

since I can make a column into a number like Selection.column will return a number for the column you are in, can I then go in reverse and make the number 4 into column D somehow??