Rayne
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or simply
=SUM(B:B,D:D)
=SUM(B:B,D:D)
ASKER