Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • 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 KwanCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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