Last non empty cell

[excellence]

Hi,
I am looking for a formula (to be located in cell H3) and would find the last non empty cell in column B and take its value which will always be a number and add to it the values of I3 and J3 which will always be numbers as well.

So, H3 would have the formula that would add the last non empty value in column B +I3 +J3

If the last cell was 800 and I3 =100 and J3=50, then H3 cell would yield 950

H3 and J3 have =SUM formulas that are adding the numbers in their respective columns…I assume that doesn't matter here. Just want to be complete

Many thanks

 

[Michael M]

Use

=INDEX(B:B,COUNTA(B:B))+I3+J3

 

[excellence]

=INDEX(B:B,COUNTA(B:B))+I3+J3

I copied and pasted this and not getting correct result

 

[Michael M]

Is the formula getting the correct cell in col B ?.
Make sure it IS the last non empty cell

 

[Michael M]

Do yo have blank cells BEFORE the last non empty cell in the column ??
If so, try

=LOOKUP(2,1/(B:B<>""),B:B)+I3+J3

 

[excellence]

This is a large sheet….was trying to upload sheet or image of a sample but can't seem to do so…sheet and image too big
In addition, if I delete the I3 and J3 from your formula on the big spreadsheet which is pasted in B3, it yields a number in column B but not the last cell

I neglected to say that there is conditional formatting which I will include to "green out" weekends if that's important.
Sorry for the confusion

 

[excellence]

Do yo have blank cells BEFORE the last non empty cell in the column ??
If so, try

=LOOKUP(2,1/(B:B<>""),B:B)+I3+J3

YES

This formula is nothing short of PERFECT
Thanks for your patience

 

[Michael M]

Glad you achieved your result...