OT: Anyone good with Google Sheets?

• OT: Anyone good with Google Sheets?
  Posted by Admin on 28 Jul, 2021 23:21
• I have a simple spreadsheet here
  

  Example_Run_Total

  Google Docs · docs.google.com

  
  
  You see that for May/June there's a running total even though there are no values for those months.
  How do I suppress the running totals to not show if the month value is blank?
  But I want the formula to be there ready for when the month value is entered.
  
  (Don't worry this does have application to the messageboard)
• 
  
• #1 Reply
  Posted by never sleep on 29 Jul, 2021 00:00
• I'm fairly handy with Google sheets. I will take a look in the morning
• 
  
• #2 Reply
  Posted by never sleep on 29 Jul, 2021 00:05
• Try changing  cell C3 to be =if(isblank(b3),,B3+C2)
  Then just copy down
  
• 
  
• #3 Reply
  Posted by never sleep on 29 Jul, 2021 08:13
• Running Total
  =if(ISBLANK(B2),,B2)
  =if(ISBLANK(B3),,B3+C2)
  =if(ISBLANK(B4),,B4+C3)
  =if(ISBLANK(B5),,B5+C4)
  =if(ISBLANK(B6),,B6+C5)
  =if(ISBLANK(B7),,B7+C6)
  =if(ISBLANK(B8),,B8+C7)
  =if(ISBLANK(B9),,B9+C8)
  =if(ISBLANK(B10),,B10+C9)
  =if(ISBLANK(B11),,B11+C10)
  =if(ISBLANK(B12),,B12+C11)
  =if(ISBLANK(B13),,B13+C12)
• 
  
• #4 Reply
  Posted by deadlyfrom5yardsout on 29 Jul, 2021 10:21
• What'd he say?
• 
  
• #5 Reply
  Posted by AdrianB on 29 Jul, 2021 12:01
• Quote from: deadlyfrom5yardsout on 29 Jul, 2021 10:21

  What'd he say?
  

  he said if a certain cell is blank then leave this one blank otherwise take the value from that cell and add the value from another cell and publish it in this cell
• 
  
• #6 Reply
  Posted by MadMax on 29 Jul, 2021 12:41
• Mornington Crescent!
 Funny x 2  View List
• 
  
• #7 Reply
  Posted by Fearless Fred on 29 Jul, 2021 13:41
• Quote from: MadMax on 29 Jul, 2021 12:41

  Mornington Crescent!
  

  
  Naah, you were in Nid so you've got to unblock the laterals first!
• 
  
• #8 Reply
  Posted by MadMax on 29 Jul, 2021 15:02
• Quote from: Fearless Fred on 29 Jul, 2021 13:41

  Naah, you were in Nid so you've got to unblock the laterals first!
  

  
  Bu%%er!
 Funny x 1  View List
• 
  
• #9 Reply
  Posted by grimsbyquin on 29 Jul, 2021 18:02
• wash them on a 40degree cycle
•