Hello,
New to posting to the forum, but a pro on looking up help via this forum. I would like to thank all those who contribute and share their insight.
I have been stewing over this for the last few days and not getting anywhere.. so I am hopeful some of you excel pros can help me.
I have a spreadsheet with a variety of transactions that took place on a given date. For example:
4/1/2015 23
4/2/2015 0
4/3/2015 63
4/4/2015 37
4/5/2015 31
4/6/2015 10
4/7/2015 15
4/8/2015 21
4/9/2015 26
4/10/2015 49
4/11/2015 61
4/12/2015 73
4/13/2015 27
4/14/2015 17
4/15/2015 31
4/16/2015 33
4/17/2015 24
4/18/2015 54
4/19/2015 71
4/20/2015 14
4/21/2015 18
4/22/2015 24
4/23/2015 21
4/24/2015 35
4/25/2015 50
4/26/2015 59
4/27/2015 19
4/28/2015 24
4/29/2015 14
4/30/2015 36
Total 980
I would like to know at which date the sum of the transactions totaled 124? Looking at the example I know that the sum of transactions was met/exceeded 124 on 4/5/2015. Once the criteria of 124 is met I want the addition of the transactions to continue to the next tier 249 and then 549 and so on and so on. Below is the table I am referencing each tier has different transaction criteria.
LowLimit HighLimit
0 124
125 249
250 549
550 749
750 949
950 99999999
I have added a spreadsheet to help illustrate my point. Any help would be appreciated. Thank you in advance.
bcmb1b
Bookmarks