DIR Return Create A Forum - Home
---------------------------------------------------------
ComeAllWithin (Harlequins Rugby)
HTML https://comeallwithin.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: ComeAllWithin Board
*****************************************************
#Post#: 72598--------------------------------------------------
OT: Anyone good with Google Sheets?
DIR By: Admin
Date: July 28, 2021, 5:21 pm
---------------------------------------------------------
I have a simple spreadsheet here
HTML https://docs.google.com/spreadsheets/d/15coe3GtYC5Hid1xfqOAyxzEWAKccFivGCI4bgXIZn4w/edit?usp=sharing
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)
#Post#: 72600--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: never sleep
Date: July 28, 2021, 6:00 pm
---------------------------------------------------------
I'm fairly handy with Google sheets. I will take a look in the
morning
#Post#: 72601--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: never sleep
Date: July 28, 2021, 6:05 pm
---------------------------------------------------------
Try changing cell C3 to be =if(isblank(b3),,B3+C2)
Then just copy down
#Post#: 72605--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: never sleep
Date: July 29, 2021, 2:13 am
---------------------------------------------------------
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)
#Post#: 72617--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: deadlyfrom5yardsout
Date: July 29, 2021, 4:21 am
---------------------------------------------------------
What'd he say?
#Post#: 72622--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: Adrian
Date: July 29, 2021, 6:01 am
---------------------------------------------------------
--- Quote from: deadlyfrom5yardsout link ---
>
> What'd he say?
>
--- End Quote ---
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
#Post#: 72626--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: MadMax
Date: July 29, 2021, 6:41 am
---------------------------------------------------------
Mornington Crescent!
#Post#: 72630--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: Fearless Fred
Date: July 29, 2021, 7:41 am
---------------------------------------------------------
--- Quote from: MadMax link ---
>
> Mornington Crescent!
>
--- End Quote ---
Naah, you were in Nid so you've got to unblock the laterals
first!
#Post#: 72635--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: MadMax
Date: July 29, 2021, 9:02 am
---------------------------------------------------------
--- Quote from: Fearless Fred link ---
>
> Naah, you were in Nid so you've got to unblock the laterals
first!
>
--- End Quote ---
Bu%%er!
#Post#: 72642--------------------------------------------------
Re: OT: Anyone good with Google Sheets?
DIR By: grimsbyquin
Date: July 29, 2021, 12:02 pm
---------------------------------------------------------
wash them on a 40degree cycle
*****************************************************
Page 1 of 1