If I have twelve sheets named Jan,Feb,Mar.....Dec, all in order from Jan-Dec. A formula in cell J2 that adds cell I2 and the last sheet's cell I2 plus as many more sheets cells I2 that there is untill Jan came up. So if sheet("July") was showing, then cell J2 on the July sheet would read all sheets from June to Januraury, cell"s I2 to get a "Year to date Total" in cell of July's cell J2. Can anyone help me w/ this formula going in to a formula bar on the spreadsheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula?
- Thread starter Todd_M
- Start date
Similar threads
- Question
