I need to write formula that allows me to identify and add the interest payments made for the Note thru September, 2020 in C6, and that can be copied over for the following years.

AutoSave Of H (H = Book1 - Excel Jose Mecias - File Home Insert Page Layout Formulas Data Review View Help Search 0 X Comments 5 === General P E S E A AutoSum" AY LU Calibri BIU - - Share O Find & Select 11 - AA - A. Wrap Text Merge & Center - ar Paste E $ -% , . 40.00 88 Insert Delete Format Ideas Conditional Format as Formatting Table Styles Cell Styles Clear Sort & Filter Editing Clipboard Font Alignment Number Cells Ideas E F G H I J K L M N O P Q R - A B 1 XYZ Company 2 September 30, 2019 3 Interest Payable (Thru Sep2020) thruSept2021 thruSept2022 thruSept2023 thruSept2024 10/1/2024 After 115 years 2025 Jan Feb Mar Apri 5 Note Due 2025 6 Total 7 2019 8 Jan 9 Feb 10 Mar 11 Apri 12 May 13 Jun 185 14 July 15 Aug 16 Sept 17 Oct 18 Nov 185 19 Dec 2020 Jan Feb Mar Apri May Jun July Aug Sept Oct Nov Dec 185 2021 Jan Feb Mar Apri May Jun July Aug Sept Oct Nov Dec 2022 Jan Feb Mar Apri May Jun July Aug Sept Oct Nov Dec 185 2023 Jan Feb Mar Apri May Jun July Aug Sept Oct Nov Dec 185 2024 Jan Feb Mar Apri May Jun July Aug Sept Oct Nov Dec 185 185 May Jun July Aug Sept Oct Nov Dec 185 185 185 185 185 185 Sheet1 Sheet2 + COUR SELITYS LU OLLIVALE VIHUS. @ J - + Ready 100%