Hello,
I am trying to do a sum on the attached document starting at cell E70 based off of the SUMIF function in those cells. However, the problem that I am having shows up starting at cell E132. I want the formula to be a running sum that will add the value of 68.889 to the values already achieved in the previous cell. So the correct number that I am looking for in this cell is 1066.669+68.889=1,135.56. And then the next cell (E133) would be 1,206.67.
Does anyone know how to do this?
Thank you!
So far as I can see... it is because you are outside the time range set in F15 & G15. This causes BO 18-20 to be blank and thus resets your formula.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Is there any way to structure the formula so that it adds the highest value from the first time frame even when it is outside of the time frame?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks