Good morning lovely peoples!!
I'm having a little trouble with some formula but not sure how to solve the issue
so basically i'm trying to use the export of this sheet for an animated graph but dont want to display information past the date that the sheet has been created for.
for example... if i have the first 2 days filled out then i dont want the cumalative populating the rest of the month.
As you can see in the image, underneath each day is 2 cells.
H19 across, calculates the sum of the days above based on a points system.
but the real problem is the one below (H20 Across). these are meant to cumalatively sum the days that have had data input in the boxes above.
The way that i'd like to set this up is so that for example, if day 3,4 and 5 have no data because someone has been off then if the boxes have 0's in them. i want the cumalative to show the number from the previous day so in this case it would be 5. however if the cells have had no data input in to it yet and it remains blank, then i dont want it to sum the cumalative.
I'm sorry if this is confusing... it confused the hell out of me writing it ?
Many thanks in advance for any help!
Aaron
I'm having a little trouble with some formula but not sure how to solve the issue
so basically i'm trying to use the export of this sheet for an animated graph but dont want to display information past the date that the sheet has been created for.
for example... if i have the first 2 days filled out then i dont want the cumalative populating the rest of the month.
As you can see in the image, underneath each day is 2 cells.
H19 across, calculates the sum of the days above based on a points system.
but the real problem is the one below (H20 Across). these are meant to cumalatively sum the days that have had data input in the boxes above.
The way that i'd like to set this up is so that for example, if day 3,4 and 5 have no data because someone has been off then if the boxes have 0's in them. i want the cumalative to show the number from the previous day so in this case it would be 5. however if the cells have had no data input in to it yet and it remains blank, then i dont want it to sum the cumalative.
I'm sorry if this is confusing... it confused the hell out of me writing it ?
Many thanks in advance for any help!
Aaron