So, with a help from great excel experts in this forum, I was able to get the formula that would give me the results for STEP 1. Now, I need help for STEP 2. F or an example, I want ABC's Session 2 for Feb-17 to be the net value of from both Jan-17 and Feb-17, which would equal to ZERO. Then for Mar-17, ABC's Session 2 would become 12. Another example would be for ABC's Session 3 for Feb-17 would be 230, netting/accumulating both Jan and Feb. Then for Mar-17, it would become 242, all of Jan, Feb, and Mar. I feel like "<="&EOMONTH should be used somewhere, but not quite sure how and where I would insert it... Greatly appreciate any help!!! 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16
This question generated 19 answers. To proceed to the answers, click here.
This thread is current as of May 24, 2017.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel