[Solved] Subtract B1 from last entry in column C

[cattlelyst]

So i want to format cell TK to take the first entry from Cell B Which will always be B1 and add it to the last entry in cell C which isn't always the last line can this be done?

Edit: Changed subject, was How to format cell to take from one line and add to another  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

It isn't clear to me what you want to do. Please upload a small example file explaining which cells you want to add and where you want the result to appear. To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response.

[cattlelyst]

Example.png (105.59 KiB) Viewed 1174 times

I hope you can see this
So i want the red to equal the orange (constant Always b1) + the last line in the purple (which ever C comes last)

[cattlelyst]

I am making a Monthly template
So this is March for Example but this time purple is at line 22
But Februrary the last entry is line 23

[cattlelyst]

So to recap Red must equal what ever B1 (orange) is plus what ever the last line in C (purple) is

[cattlelyst]

Sorry I stand corrected lol Red Must equal Purple ( last line in C) minus Orange (First line in B)

[FJCC]

If all the cells in column C are filled until the one you want, you can use

Code: Select all

=INDEX(C1:C100;COUNT(C1:C100)) - B1

Edit: And all the cells after the one your want are empty until the end of the range C1:C100. Of course you can adjust C1:C100 to fit your needs.

[cattlelyst]

awesome thank you so much

[cattlelyst]

that will work perfect
I'm digitizing my Ledger for work for Kilometers driven for work vs Kilometers driven for personal and I want my year end to be as simple as possible and that formula makes it so.
saved to my template you're my hero