I've got a simple problem that's driving me crazy. I need the function name(s) that will allow me to "attach" a number (in a separate cell) to a column letter to create a cell designation o use in a sum formula. It's driving me crazy because i did it about two years ago, and then my computer and Time Machine backup had a fit - no backup, no file.
Briefly, I have a spreadsheet of ten columns (one a date column), added to daily (almost 700 rows to date). The problem is to run different totals based on different dates, and, as a further complication, I have to keep a file of weekly totals. This worked fine using two "source" cells to define the row numbers and having a formula which attach the column letter to the row numbers in the cells.
It seemed so simple two years ago........ Help. Thanks
Briefly, I have a spreadsheet of ten columns (one a date column), added to daily (almost 700 rows to date). The problem is to run different totals based on different dates, and, as a further complication, I have to keep a file of weekly totals. This worked fine using two "source" cells to define the row numbers and having a formula which attach the column letter to the row numbers in the cells.
It seemed so simple two years ago........ Help. Thanks