Hello,
I have this formula for a cell:
SUM(INDIRECT("C"&A18):INDIRECT("C"&B18))
How can I dynamially reference the column in which the cell is in,
rather than using "C", as shown above?
Thank you.
Kelie
Hello,
I have this formula for a cell:
SUM(INDIRECT("C"&A18):INDIRECT("C"&B18))
How can I dynamially reference the column in which the cell is in,
rather than using "C", as shown above?
Thank you.
Kelie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks