Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

Summation Total Excel

Hi,
How do I set up a formula in Running Total column, that shows up only one number that totals the sum of numbers on column B and D as shown. Keep in mind that users will enter more numbers with time, so the source for the running total should be dynamic and takes any numbers that are in those rows and sums them.

Now let's say there are new row values in column B = 1 and column D = 2,
¿then the previous total [47] now becomes 50


I have attached the sample excel.

Thanks in advance. Help is greatly appreciated.

-Rayne
total-summation.xlsx
0
Rayne
Asked:
Rayne
1 Solution
 
Peter KwanAnalyst ProgrammerCommented:
Replace your existing formula at cell E4 with "=SUM(B:B)+SUM(D:D)". Does it suit your need?
0
 
RayneAuthor Commented:
Thank Pkwan, that works great!!
0
 
Saqib Husain, SyedEngineerCommented:
Or simply

=SUM(B:B,D:D)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now