https://www.photobox.co.uk/my/photo/full?photo_id=502027697277
I'm currently working on a project for an investment company to find how much money has been committed at any specified point in time. I'm using the array formula shown to find this amount. The next thing I want to do is find the max total commitment for the reference date. Right now, I have a running list of calculations based on 15 minute intervals and am running a MAX formula on that, but the volume of calculations occurring to do this is slowing my computer down considerably. I'm also running a risk of not finding the true max value, because some commitments can last less than a minute or two, but they need to be taken into consideration for the purpose of the exercise. I could decrease the time intervals, but that would make my slowdown issue even worse. Is there a formula I can use that can find the max sum of all sums that meet the range criteria?
I'm currently working on a project for an investment company to find how much money has been committed at any specified point in time. I'm using the array formula shown to find this amount. The next thing I want to do is find the max total commitment for the reference date. Right now, I have a running list of calculations based on 15 minute intervals and am running a MAX formula on that, but the volume of calculations occurring to do this is slowing my computer down considerably. I'm also running a risk of not finding the true max value, because some commitments can last less than a minute or two, but they need to be taken into consideration for the purpose of the exercise. I could decrease the time intervals, but that would make my slowdown issue even worse. Is there a formula I can use that can find the max sum of all sums that meet the range criteria?
