Excel Formula Problem

Joined
Jun 4, 2010
Messages
8
Reaction score
0
Points
1
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
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top