Formula for addressing final cells in columns

R

rcp

New Member
Joined
Dec 3, 2020
Messages
16
Office Version
  1. 2019
Platform
  1. MacOS
I have three columns (B, C, D) all with figures in, and I'd like a formula to give me the total value of the last filled cell in each column. (Let's say for instance I have six entries in each, obviously it would be SUM(B6+C6+D6), but I am going to keep adding values monthly into each column, so I need that reference point to move down a row with each time it is filled in
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

W
  • Question
SCHEDULE DASHBOARD VBA CODE (AUTOMATCICALLY TOGGLE TO MATCHING COLUMN)
Replies
0
Views
103
Willkim
W
A
  • Question
Dynamically add new rows via VBA when using IFERROR TEXTJOIN and FILTER formulas from Table?
Replies
0
Views
143
AlfredDB
A
I
  • Solved
Cell above is selected when i duplicate row
Replies
2
Views
106
ipbr21054
I
T
  • Solved
A more elegant countifs criteria than "$B6-$B5/1<0" across 50 columns
Replies
3
Views
257
tekram
T
F
  • Question
Rounding values to 2 decimel while keeping total 100%
2 3 4
Replies
38
Views
531
awoohaw
awoohaw

Forum statistics

Threads
1,215,516
Messages
6,125,284
Members
449,218
Latest member
Excel Master

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top