SOLVED

Resetting Cumulative count

Copper Contributor

Hi, 
I'm looking at a way to reset my occupancy column at midnight every night, any help would be really appreciated :),

Thanks,
Molly

6 Replies

@mh1245 

Your workbook constantly asks for credentials for a MySQL database...

Apologies id uploaded the wrong one, ive changed it now :)
best response confirmed by mh1245 (Copper Contributor)
Solution

@mh1245 

In G2:

 

=MAX(0,IF(F2<>F3,0,G3)+A2-B2)

 

Fill down.

Thats perfect, thank you so much ! do you know if in the future there would be anyway to reset it depending on time, i.e. 4am etc ? Sorry just new to all of this

@mh1245 

 

Use this formula:

 

=MAX(0,IF(OR(AND(F2<>F3,E2>=4),AND(F2=F3,E2>=4,E3<4)),0,G3)+A2-B2)

Perfect, thanks so much :)
1 best response

Accepted Solutions
best response confirmed by mh1245 (Copper Contributor)
Solution

@mh1245 

In G2:

 

=MAX(0,IF(F2<>F3,0,G3)+A2-B2)

 

Fill down.

View solution in original post