Hi I have a problem with a formula where I am trying to get a total flow per 24 hours.
My columns are referenced by date with data every two minutes with flow creating an increasing total over time.
My one formula at the moment is for example =sum(C200-C20) which subtracts the end total from the start total to give me a snapshot of that day. The next days data is C900-C201 if I look manually but I do not know how to create a formula which will allow me to do this day after day from the start and telling excel to reference cells 700 rows down and so on from the previous day.
Is this an easy fix?