Current Months Profit Thus Far / Return furthest down filled cell

[ephipps12]

I'd like to begin with this is my first post. I have learned a lot from you all and have made a spreadsheet for my inventory that I am so very proud! Thank you very much!


I have simplified the data to make this easier, but in short:


I have 4 different sales categories: General / Cars / Bikes / Commission

Each category has it's monthly profits calculated. I also have a Monthly Grand Total section where each categories monthly profit total is added all together.

I would like a cell; I17, to show the Current Months Profit Thus Far. In the attached spreadsheets example, it would show O7's value essentially. When next month July comes around, I'd like it to start automatically tracking that month and so on. I have spent hours on end trying to figure out a way and just can't seem to figure it out. I would imagine it could be done as I'm describing, or even as simple as having it return the furthest down filled cell in that column. I may be over thinking it.


Help.

[cubangt]

You can use vlookup like this

=VLOOKUP(TEXT(NOW(), "mmm"),N2:O13,2)

I have attached your file with this in place.

[ephipps12]

You can use vlookup like this

=VLOOKUP(TEXT(NOW(), "mmm"),N2:O13,2)

I have attached your file with this in place.

This didn't work. I went to fill in data for July and it didn't update the I17 cell with the new values that would be in O8.

[cubangt]

It wont update until we are in July.. You are wanting current month, and thats what the NOW() portion is doing, its taking todays date and returning the 3 letter abbr for the month, so if you want to test it out for other months, then you need to replace the NOW() with another date and it should work.. Make sure its a properly formatted date for it to return the correct abbrv.

[ephipps12]

It wont update until we are in July.. You are wanting current month, and thats what the NOW() portion is doing, its taking todays date and returning the 3 letter abbr for the month, so if you want to test it out for other months, then you need to replace the NOW() with another date and it should work.. Make sure its a properly formatted date for it to return the correct abbrv.

Ah that's right. Perfect, Thanks, You're the best! Happen to have a pay pal, cash app, or venmo? I'd love to send you an appreciation tip to buy your next beer.

[cubangt]

Ah that's right. Perfect, Thanks, You're the best! Happen to have a pay pal, cash app, or venmo? I'd love to send you an appreciation tip to buy your next beer.

Appreciate it, but no need.. glad it helped. just add the reputation at the bottom my post is plenty.

thanks.

[ephipps12]

Oops. Couldn't figure out how to delete this reply; see below for what I meant to type.

[ephipps12]

It wont update until we are in July.. You are wanting current month, and thats what the NOW() portion is doing, its taking todays date and returning the 3 letter abbr for the month, so if you want to test it out for other months, then you need to replace the NOW() with another date and it should work.. Make sure its a properly formatted date for it to return the correct abbrv.

So now that we are in July and I have made sales and input the data, this did not update correctly. Instead the box is now showing the total for Feb.

[josephteh]

If what you desire is the last value in the range O2:O13 that's not equal to zero, then formula = LOOKUP(2,1/((O2:O13)<>0),O2:O13)