Forum Discussion

Tbarber's avatar
Tbarber
Copper Contributor
Nov 27, 2020

running total?

I am using an running total but having trouble to have the Total cell blank until data is entered for that line. This is all because I set the formula for the whole column. See the following example and how can I clear C5 and C6 until data is entered?

 

Thank you

 

Tom

 
excel

3 Replies

  • adversi's avatar
    adversi
    Iron Contributor
    Nov 27, 2020

    Tbarber 

    You will need to apply an IF condition to have the Running Sum blank until a value is inputted. Your new formula would be (starting from the first SUM cell)

    =IF(B3="",,SUM($B$3:B3))

     

    • Tbarber's avatar
      Tbarber
      Copper Contributor
      Nov 27, 2020

      adversi 

       

      That's great thanks, I guessed there would be a IF statement somewhere. Except in the fields where there is not input data yet it places a 0 in Total sum cell. Think there is a way just to have it blank?

       

      Tom

      • adversi's avatar
        adversi
        Iron Contributor
        Nov 27, 2020

        Tbarber 

        Yes, you can see that by default, when there is nothing in the TRUE statement in the IF statement, the value is 0. To edit this, a "" needs to be added in that section. The new formula will be:

        =IF(B3="","",SUM($B$3:B3))

Resources