Entry to change for current month

[liltechy]

I have a financial workbook and need some assistance with a formula. sheet1 is where I enter my monthly totals. Sheet2 is the financial report. What I can't figure out is what formula do I use to have the current month's entry show up on Sheet2. Here is what sheet1 looks like:

Acct# Descr. Jan Feb Mar Apr May Jun Jul Aug
30021 Grants 1500 2500 2502 1100 1500 250 110 1800

Sheet2
Acct# Descr. YTD Current Month
30021 Grants 11262 1800

What I need is for the current month on sheet2 to change to whatever the last entry is on sheet1

Please help

liltechy

 

[mbarron]

You can use the OFFSET function to accomplish this.
Assuming that the "Grant" is in cell B2 on sheet one and that you are only going from January to December.

=OFFSET(Sheet1!$B$2,0,COUNT(Sheet1!$B$2:$N$2))

Mike

 

[liltechy]

Thanks so much that works great.

liltechy