To aggregate data by time period, first click on the entire row of years (or quarter and year) in the detailed sheet with periodic data and press the F4 shortcut ... The SUMIF function using this idea is illustrated in the two formulas in Figure 15.3.
Title | : | Corporate and Project Finance Modeling |
Author | : | Edward Bodmer |
Publisher | : | John Wiley & Sons - 2014-10-10 |
You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.
Once you have finished the sign-up process, you will be redirected to your download Book page.
How it works: