Total Interest Lookup

[rickparker]

Very basic Mortgage Amort table. Using the DTPicker21 no problem.

Column B18..b377 is Payment Date (1st payment due date beginning with date in B18)
Column H12..H377 is interest component for repective rate,term and balance monthly;

I want to lookup based on the date picker21, move from that date/row in Column B to H Column and sum the interest from that row to the H377 limit (last payment due row).

As always. . . thanks for feedback
Rick Parker

[Roshan10043]

Hi,

if i have understood your query you want to sum from column H18 till the row the date is found in Column B. If this is true, then below is the solution (replace G12 in the match function with the dtpicker value):

Please Login or Register  to view this content.

[Cutter]

Try SUMIF() function:

=SUMIF(B18:B377,">="&C2,"H18:H377) where C2 holds the DTPicker value