How Do I Create an Absolute Value Running Total or that's what I think it's called.
Let's say I have a column of numbers like this
5
2
8
-9
-5
-15
4
8
7
-6
-4
-2
-8
5
-4
7
and I want to have a running total in the cell directly to the right of these numbers that did a running total average of each number where the formula will figure out that it will translate all the negative (-) numbers are to be read as positive numbers and formulating it's average so all the negative number will be counted as a positive number like this
5
2
8
9
5
15
4
8
7
6
4
2
8
5
4
7
then the formula will give a running average of the first 2 cells of the numbers 5 and 2 and then the next cell to the left that says 5 and 2 and 8 will give the running total of those 3 numbers written in the cell directly to the right of each number listed. and then the average will be given of the absolute numbers will list the average of the first 4 numbers listed of 5 and 2 and 8 and 9 etc.
This formula should be able to be dragged down the excel page so it wouldn't matter how long the list of number were it will give the absolute running total numbers all the way down.
I'm not that good in understanding the math side of these problems. So I'm sure I'm not explaining to the right way. But I hope you understand what I mean.
So
Number 1) All the numbers listed in Cell A will be read in the formula Cell B as positive numbers only.
Number 2) All the averages are in a running total down Cell B and the averages are based on each number combination of the total numbers above it only.
Example
Cell 1) 5 (Taking the average of the number 5 only = 5)
Cell 2) 2 (Taking the average of both the number 5 and the number 3 =)
Cell 3) 8 (Taking the average of all 3 numbers of the 5 and 3 and 8)
Cell 4) 9 (Taking the average of all 4 numbers of the 5 and 3 and 8 and 9)
Cell 5) 5 (Taking the average of all 5 numbers of the 5 and 3 and 8 and 9 and 5) Etc. Etc.
I hope I explained what I'm trying to do correctly.
Thanks for any help you can give me on this to create the formula I need,
Zotah
Let's say I have a column of numbers like this
5
2
8
-9
-5
-15
4
8
7
-6
-4
-2
-8
5
-4
7
and I want to have a running total in the cell directly to the right of these numbers that did a running total average of each number where the formula will figure out that it will translate all the negative (-) numbers are to be read as positive numbers and formulating it's average so all the negative number will be counted as a positive number like this
5
2
8
9
5
15
4
8
7
6
4
2
8
5
4
7
then the formula will give a running average of the first 2 cells of the numbers 5 and 2 and then the next cell to the left that says 5 and 2 and 8 will give the running total of those 3 numbers written in the cell directly to the right of each number listed. and then the average will be given of the absolute numbers will list the average of the first 4 numbers listed of 5 and 2 and 8 and 9 etc.
This formula should be able to be dragged down the excel page so it wouldn't matter how long the list of number were it will give the absolute running total numbers all the way down.
I'm not that good in understanding the math side of these problems. So I'm sure I'm not explaining to the right way. But I hope you understand what I mean.
So
Number 1) All the numbers listed in Cell A will be read in the formula Cell B as positive numbers only.
Number 2) All the averages are in a running total down Cell B and the averages are based on each number combination of the total numbers above it only.
Example
Cell 1) 5 (Taking the average of the number 5 only = 5)
Cell 2) 2 (Taking the average of both the number 5 and the number 3 =)
Cell 3) 8 (Taking the average of all 3 numbers of the 5 and 3 and 8)
Cell 4) 9 (Taking the average of all 4 numbers of the 5 and 3 and 8 and 9)
Cell 5) 5 (Taking the average of all 5 numbers of the 5 and 3 and 8 and 9 and 5) Etc. Etc.
I hope I explained what I'm trying to do correctly.
Thanks for any help you can give me on this to create the formula I need,
Zotah