How can I use a value from a cell to refer to a particular row in Excel?

Gil

New member
Joined
Jul 6, 2008
Messages
21
Reaction score
0
Points
1
I am trying to calculate the sum of a range of cells in Excel. I want the range to be from B3 to Bx where x is a changing value that corresponds to today's date, so that the sum changes each day automatically. How can I make a value x that corresponds to a certain value, and how do I put this inot the formula for the sum?
 
Back
Top