Forum Discussion
Adding number in the same table
Tia Rojas ah Mathetes is ever the teacher. I will be the bad student...
assuming "miles" is in Col. C then I believe what you want is:
Col E "Total Miles" would be
=if(d2=0,c2+e1,0)
and Col F "Sum of Miles" would be
=if(d2=0,0,c2+e1)
Thank you for the help. That is not going to work because I am in the process of creating the e column.
I need to do something like this:
If fuel <> 0 then Total miles = 0 and h=0 <--- I will have to add a new column to save a value
If fuel = 0 then Total mile = Miles + h and h= miles
If fuel <> 0 then Sum Numbers = Miles + Total Miles
if Fuel = 0 Then Sum Numbers = 0
This will give the correct values for columns e=Total Miles and f=Sum number
I can program in DAX and Java or any object oriented langue so I am finding exxel difficult.
Thank you
Tia Rojas I think your trouble might be in understanding that in Excel the "Formula" in the cell is hidden and used to show the RESULT of that formula. So if you type a formula like =A1+B1 in a cell you don't see that text but instead the result of A1+B1.
So if you paste the formula I gave you in the columns where you need those answers they will show the results you want. Try it out, I think you'll catch on quickly.
tarlerI tried your formulas and I am getting the incorrect result because is not doing the addition that I need:
Please take a look at your formula and the result that I get. What I need to get is in red
To get the correct result in the top picture I need something like this:
If D5 <> 0 then f5 = 0 and $h$1=0 <--- h1 is a holder and need to change to do an addition
If D5 = 0 then F5 = C5 + $h$1 and $h$1= C5If D5 <> 0 then G5 = C5 + F4 (I will have put a 0 on F4 to initialize)
if D5 = 0 Then G5 = 0