Referencing Last Cell
You're welcome.
"jlo" wrote in message
...
Thank you. You are the best!!! Works like I want it to work!
"Gaurav" wrote:
=LOOKUP(2,1/(B21:M21<""),B21:M21)
This will return the last (Right Most) value entered in this range.
"jlo" wrote in message
...
Works great except I don't want a sum, I just want the current value
for
the
current month. Thanks.
"Bob Phillips" wrote:
=SUM(B20:INDEX(B21:M21,MONTH(TODAY())))
--
__________________________________
HTH
Bob
"jlo" wrote in message
...
I have a spreadsheet that has total hours for Jan, Feb, Mar, Apr,
May,
Jun,
Jul, Aug, Sep, Oct, Nov, Dec. (B21:M21) In these fields are values
up
until
the current month.
I have a field called Total Hours (B7). How can I get this cell to
reference the current month? Can it be done?
So for this month I keyed 144 in the month of Aug and I want the
field
Total
Hours to reflect that total automatically. For next month, it
should
change
to the figure keyedin Sep.
|