Excel. simple formula. 2 columns A B. A cash B running total A. But I need the next B row to be blank or 0.?

I am 64 and very rusty on Excel. What I am trying to do is set a very basic spreadsheet for each person to track the monthly sales. A- for entering the amt B to have a running total. Basic formula in B4 =SUM(B3+A4) The formula continues down the page. I need the next B row to be blank or 0 until a dollar amt is entered in A. I have tried IF and SUMIF formulas but must be entering info wrong.


I would appreciate any help anyone can give me.


The other is to track average call handle time(we have a 176 goal). 4 columns: A # of Calls--B Time(how long the call was) C Total Time D AHT (Average Handle Time). A- I have numbered down the column B-This is the column to type in How long the call was C2.=SUM(B2) D- +SUM(C2/A2*60) and then in C3 =SUM(B3+C2).I hide C to stop confusion But I have the same problem with D, the formula continues down the page and it confuses a lot of people, so am trying to set it so the last time they see in D is the current AHT.|||For the first problem of tracking monthly sales the following formulae should be used


A B


1 AmountTotal


2 125=A2


3 130=IF(A3%26lt;%26gt;"",SUM(B2+A3),"")


4 _=IF(A4%26lt;%26gt;"",SUM(B3+A4),"")





Which will result in





AB


1AmountTotal


2125125


3130255


4__





For the second problem of calculating Average times the following formulae should be used





AB C D


1 CallsTime Total Average


2 12 =B2 =(C2/A2)*60


3 21 =IF(B3%26lt;%26gt;"",SUM(B2+C3),"") =IF(C3%26lt;%26gt;"",(C3/A3)*60,"")


4 _ _ =IF(B4%26lt;%26gt;"",SUM(C3+B4),"") =IF(C4%26lt;%26gt;"",(C4/A4)*60,"")





Which results in





ABCD


1No CallsTimeTotal TimeAverage Time


2122120


321390


4 _ _ _ _





unfortunately you would still have the problem of hiding column C, it can however be calculated without using 4 colmuns by using the following formulae





A B C


1 Calls Time Average Time


2 1 2 =(B2/A2)*60


3 2 1 =IF(B3%26lt;%26gt;"",(SUM($B$2:B3)/A3)*60,"")


4 3 _ =IF(B4%26lt;%26gt;"",(SUM($B$2:B4)/A4)*60,"")





which gives the average without having to display the total as below





ABC


1 CallsTimeAverage Time


2 12120


3 2190


4 3 _ _





Hope this helps, the underscores(_) indicate an empty cell|||In B: =IF(A2%26lt;%26gt;"",SUM(B1+A2),0)


or =IF(A2%26lt;%26gt;"",SUM(A2),"")





Also, I'm a little confused on the call tracking sheet, but why not create a summary row at the bottom of the sheet to indicate that that's where people should be looking (color it and mark it off with borders)?