Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get the error back. Right now I have:
=SUM[PREV BILLINGS]2:[([JAN-18]2)+($Type$165)]2
where the "Type165" references the number to input for "X". "PREV BILLINGS" and "JAN-19" are current Column names. Any help is appreciated, thank you.