Look Up Row to Sum when criteria don't align

K

kgebert

New Member
Joined
May 10, 2013
Messages
1
I am trying to create a summary table at the top of a sheet that contains several investments and their corresponding cash flows. Each investment is listed in column B from row 258:500 and has an identical number of rows below it containing various cash flows in it. For example, the name INVESTMENT X would be in B258 and in cells C259:C269 are titles such as LOC draw, Equity invested, inflow, and outflow with the data by quarters running from column E to BB.

I need to make a table that sums inflows and outflows by year for each investment. Investment names will be in Column A and years in cells B5:K5. So I need a formula that will find and sum by year the row titled Inflow (or outflow) for each investment. Sumif and sumifs aren't working for this.

Since we will have a number of investments, I want a formula that can auto-summarize when I add a new investment so I don't have to do it by hand.

I've attached an example below. All investments are entered the same way with the same # of rows and spacing. Any help I can get on this would be great. Thanks
[TABLE="width: 1188"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Summary Table [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Investment Outflows[/TD]
[TD]2012[/TD]
[TD]2013[/TD]
[TD]2014[/TD]
[TD]2015[/TD]
[TD]2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Investment X [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Investment Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Net Inflows[/TD]
[TD]2012[/TD]
[TD]2013[/TD]
[TD]2014[/TD]
[TD]2015[/TD]
[TD]2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Investment X [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Investment Y[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2012[/TD]
[TD]2012[/TD]
[TD]2012[/TD]
[TD]2013[/TD]
[TD]2013[/TD]
[TD]2013[/TD]
[TD]2013[/TD]
[TD]2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6/30/2012[/TD]
[TD]9/30/2012[/TD]
[TD]12/31/2012[/TD]
[TD]3/31/2013[/TD]
[TD]6/30/2013[/TD]
[TD]9/30/2013[/TD]
[TD]12/31/2013[/TD]
[TD]3/31/2014[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]INVESTMENT X [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model Outflow[/TD]
[TD](57,550,000)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-7550000[/TD]
[TD]-50,000,000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model AM & Promote[/TD]
[TD](3,020,081)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-19,190[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-125,000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model Gross Inflow[/TD]
[TD]110,337,446[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]6,139,399[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3,587,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]LOC Draws[/TD]
[TD](7,550,000)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD](7,550,000)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AM Funded on LOC[/TD]
[TD](3,000,891)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](125,000)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Equity Invested[/TD]
[TD](50,145,546)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](45,546)[/TD]
[TD](50,100,000)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Gross Cash Inflow[/TD]
[TD]110,337,446[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]6,139,399[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3,587,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AM & Promote to Partner[/TD]
[TD](3,038,279)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](18,772)[/TD]
[TD](18,616)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](125,000)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Gross Cash Flows[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](7,550,000)[/TD]
[TD](45,546)[/TD]
[TD](43,960,601)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3,587,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Investment Outflows[/TD]
[TD](57,695,546)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD](7,550,000)[/TD]
[TD](45,546)[/TD]
[TD](50,100,000)[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Net Inflows[/TD]
[TD]107,299,167[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](18,772)[/TD]
[TD]6,120,783[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3,462,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Net Cash Inflow[/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] (18,772)[/TD]
[TD] 6,120,783[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] 3,462,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Net Base Case Cash Flows[/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] (7,550,000)[/TD]
[TD] (64,318)[/TD]
[TD] (43,979,217)[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] 3,462,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model Net IRR[/TD]
[TD]15.95%[/TD]
[TD] 1.82[/TD]
[TD][/TD]
[TD][/TD]
[TD] (7,550,000)[/TD]
[TD] (50,019,190)[/TD]
[TD] 6,139,399[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] 3,462,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]LOC Cash Flow IRR[/TD]
[TD]127.80%[/TD]
[TD] 14.22[/TD]
[TD][/TD]
[TD][/TD]
[TD] (7,550,000)[/TD]
[TD] -[/TD]
[TD] 6,139,399[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] 3,462,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Equity CF IRR[/TD]
[TD]17.49%[/TD]
[TD] 1.96[/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] (64,318)[/TD]
[TD] (43,979,217)[/TD]
[TD] -[/TD]
[TD] (7,550,000)[/TD]
[TD] 3,462,197[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Drawn on LOC to Quarter End[/TD]
[TD]-7,550,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Assumed Payback Quarter[/TD]
[TD]12/31/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Gross IRR[/TD]
[TD]17.67%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Net IRR[/TD]
[TD]16.84%[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Gross Multiple[/TD]
[TD] 1.91[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Net Multiple[/TD]
[TD] 1.86[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]INVESTMENT Y [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Correct for Model-Actual Difference[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]-2,044,886[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model Outflow[/TD]
[TD](10,166,776)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] (7,360,272)[/TD]
[TD] (1,124,082)[/TD]
[TD] (3,574,678)[/TD]
[TD] (2,955)[/TD]
[TD] (51,420)[/TD]
[TD] (2,955)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model AM & Promote[/TD]
[TD](743,650)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-11,903[/TD]
[TD]-15,121[/TD]
[TD]-17,951[/TD]
[TD] (18,750)[/TD]
[TD] (18,750)[/TD]
[TD] (18,750)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model Gross Inflow[/TD]
[TD]16,060,835[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]LOC Draws[/TD]
[TD](10,193,799)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD](6,113,271)[/TD]
[TD](353,221)[/TD]
[TD](3,574,678)[/TD]
[TD](2,955)[/TD]
[TD](51,420)[/TD]
[TD](2,955)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AM Funded on LOC[/TD]
[TD](716,627)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](17,951)[/TD]
[TD](18,750)[/TD]
[TD](18,750)[/TD]
[TD](18,750)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Equity Invested[/TD]
[TD](3,727,307)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](3,574,678)[/TD]
[TD](2,955)[/TD]
[TD](51,420)[/TD]
[TD](2,955)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Gross Cash Inflow[/TD]
[TD]16,060,835[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]AM & Promote to Partner[/TD]
[TD](716,627)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](17,951)[/TD]
[TD](18,750)[/TD]
[TD](18,750)[/TD]
[TD](18,750)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Gross Cash Flows[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD](6,113,271)[/TD]
[TD](353,221)[/TD]
[TD](3,574,678)[/TD]
[TD](2,955)[/TD]
[TD](51,420)[/TD]
[TD](2,955)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Investment Outflows[/TD]
[TD](10,193,799)[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD](6,113,271)[/TD]
[TD](353,221)[/TD]
[TD](3,574,678)[/TD]
[TD](2,955)[/TD]
[TD](51,420)[/TD]
[TD](2,955)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Net Inflows[/TD]
[TD]15,344,208[/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD](17,951)[/TD]
[TD](18,750)[/TD]
[TD](18,750)[/TD]
[TD](18,750)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Net Cash Inflow[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] (17,951)[/TD]
[TD] (18,750)[/TD]
[TD] (18,750)[/TD]
[TD] (18,750)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Net Cash Flows[/TD]
[TD] 5,150,409[/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] (6,113,271)[/TD]
[TD] (353,221)[/TD]
[TD] (3,592,629)[/TD]
[TD] (21,705)[/TD]
[TD] (70,170)[/TD]
[TD] (21,705)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Model Net IRR (Initial Check)[/TD]
[TD]10.04%[/TD]
[TD] 1.51[/TD]
[TD][/TD]
[TD][/TD]
[TD] (7,372,175)[/TD]
[TD] (1,139,203)[/TD]
[TD] (3,592,629)[/TD]
[TD] (21,705)[/TD]
[TD] (70,170)[/TD]
[TD] (21,705)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]LOC Cash Flow IRR[/TD]
[TD]19.05%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] (6,113,271)[/TD]
[TD] (353,221)[/TD]
[TD] (3,592,629)[/TD]
[TD] (21,705)[/TD]
[TD] (70,170)[/TD]
[TD] (21,705)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Equity CF IRR[/TD]
[TD]26.88%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD] (3,592,629)[/TD]
[TD] (21,705)[/TD]
[TD] (6,536,662)[/TD]
[TD] (21,705)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Drawn on LOC to Quarter End[/TD]
[TD]-6,466,492[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Assumed Payback Quarter[/TD]
[TD]12/31/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Gross IRR[/TD]
[TD]21.35%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Net IRR[/TD]
[TD]19.05%[/TD]
[TD]-3,684,503[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Gross Multiple[/TD]
[TD] 1.58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Net Multiple[/TD]
[TD] 1.51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
The simplest way I can think of doing that is to add Investment X under column B in rows 259:269. You can do the same for every other section that you have for investments. Your Sumifs would work by doing this and referring to column B and the year. You can always just change the font color to white for everything in column B except for the heading of the investment section...

Make sense?
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
Dynamic XIRR for sum of CF's with Offset
Replies
3
Views
4K
DRSteele
DRSteele
P
  • Solved
Computing investment return formula
Replies
8
Views
762
polarwoc
P
L
  • Question Question
Private Equity IRR Calc
Replies
0
Views
1K
lordrummxx1
L
D
  • Question Question
Help Needed to Resolve Sum issue with Positive and Negative Values
Replies
4
Views
556
djbush3
D
H
  • Question Question
Complicated Calculation
Replies
6
Views
2K
Eric W
Eric W

Forum statistics

Threads
1,226,882
Messages
6,193,481
Members
453,803
Latest member
hbvba

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top