Spreadsheet: 864271d1711494107-help-needed-to-create-formula-to-display-amts-for-specific-months-only-trash-pmts-sample-3-26-24
Sheet: Sheet1

 | TRASH REMOVAL |  | January - December |  | YEAR- | 2024-01-01 00:00:00 |  |  |  |  |  |  |  | Years
 |  |  | Amt spent in selected Year ---> |  |  |  |  | [NAME] needed to show the amount of payment only if:  1) the  current Month is one of the ones shown in cells i10 through L10 i.e. [NAME],[NAME] ,Sept,Dec 2) and the year is equals the one shown in cell G1
 |  |  | Total Year To Date  ----> |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  | Average Monthly    ----> |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00
 |  |  | Amt spent this Month ---> |  |  |  |  |  |  |  |  |  |  | 2025-01-01 00:00:00
 |  |  | Cost Per Wk    ----> |  |  |  |  |  |  |  |  |  |  | 2026-01-01 00:00:00
 |  |  | Extra Disposal Charges Yr to Dt    ----> |  |  |  |  |  |  |  |  |  |  | 2027-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2028-01-01 00:00:00
 | Coverage    Period |  |  |  |  |  |  |  |  |  |  |  |  | 2029-01-01 00:00:00
 | From | To | Date PD | Reg Monthly Pmt | Extra Chrgs | Total PD |  | Pmt Made |  |  |  |  |  | 2030-01-01 00:00:00
2022-12-24 00:00:00 | Jan 1st | 2022-03-31 00:00:00 | 2022-03-08 00:00:00 | 105 | 0 |  |  |  |  |  |  |  |  | 2031-01-01 00:00:00
 | Apr 1st | 2022-06-30 00:00:00 | 2022-06-09 00:00:00 | 123 | 0 |  |  |  |  |  |  |  |  | 2032-01-01 00:00:00
 | Jul 1st | 2022-09-30 00:00:00 | 2022-09-06 00:00:00 | 93 | 0 |  |  |  |  |  |  |  |  | 2033-01-01 00:00:00
 | Oct 1st | 2022-12-31 00:00:00 | 2022-12-13 00:00:00 | 111 | 0 |  |  |  |  |  |  |  |  | 2034-01-01 00:00:00
2023-12-24 00:00:00 | Jan 1st | 2023-03-31 00:00:00 | 2023-03-07 00:00:00 | 111 | 0 |  |  |  |  |  |  |  |  | 2035-01-01 00:00:00
 | Apr 1st | 2023-06-30 00:00:00 | 2023-06-13 00:00:00 | 111 | 0 |  |  |  |  |  |  |  |  | 2036-01-01 00:00:00
 | Jul 1st | 2023-09-30 00:00:00 | 2023-09-13 00:00:00 | 117 | 5 |  |  |  |  |  |  |  |  | 2037-01-01 00:00:00
 | Oct 1st | 2023-12-31 00:00:00 | 2023-12-13 00:00:00 | 102 | 0 |  |  |  |  |  |  |  |  | 2038-01-01 00:00:00
2024-12-24 00:00:00 | Jan 1st | 2024-03-31 00:00:00 | 2024-03-15 00:00:00 | 118.5 | 0 | 118.5 |  |  |  |  |  |  |  | 2039-01-01 00:00:00
 | Apr 1st | 2024-06-30 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2040-01-01 00:00:00
 | Jul 1st | 2024-09-30 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2041-01-01 00:00:00
 | Oct 1st | 2024-12-31 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2042-01-01 00:00:00
2025-12-24 00:00:00 | Jan 1st | 2025-03-31 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2043-01-01 00:00:00
 | Apr 1st | 2025-06-30 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2044-01-01 00:00:00
 | Jul 1st | 2025-09-30 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2045-01-01 00:00:00
 | Oct 1st | 2025-12-31 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2046-01-01 00:00:00
2026-12-24 00:00:00 | Jan 1st | 2026-03-31 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2047-01-01 00:00:00
 | Apr 1st | 2026-06-30 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2048-01-01 00:00:00
 | Jul 1st | 2026-09-30 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2049-01-01 00:00:00
 | Oct 1st | 2026-12-31 00:00:00 |  | 0 | 0 |  |  |  |  |  |  |  |  | 2050-01-01 00:00:00
2027-12-24 00:00:00 | Jan 1st | 2027-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 2027-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 2027-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 2027-12-31 00:00:00 |  | 0 | 0
2028-12-24 00:00:00 | Jan 1st | 2028-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 2028-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 2028-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 2028-12-31 00:00:00 |  | 0 | 0
2029-12-24 00:00:00 | Jan 1st | 2029-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 2029-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 2029-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 2029-12-31 00:00:00 |  | 0 | 0
2030-12-24 00:00:00 | Jan 1st | 1930-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1930-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1930-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1930-12-31 00:00:00 |  | 0 | 0
2031-12-24 00:00:00 | Jan 1st | 1931-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1931-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1931-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1931-12-31 00:00:00 |  | 0 | 0
2032-12-24 00:00:00 | Jan 1st | 1932-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1932-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1932-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1932-12-31 00:00:00 |  | 0 | 0
2033-12-24 00:00:00 | Jan 1st | 1933-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1933-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1933-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1933-12-31 00:00:00 |  | 0 | 0
2034-12-24 00:00:00 | Jan 1st | 1934-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1934-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1934-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1934-12-31 00:00:00 |  | 0 | 0
2035-12-24 00:00:00 | Jan 1st | 1935-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1935-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1935-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1935-12-31 00:00:00 |  | 0 | 0
2036-12-24 00:00:00 | Jan 1st | 1936-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1936-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1936-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1936-12-31 00:00:00 |  | 0 | 0
2037-12-24 00:00:00 | Jan 1st | 1937-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1937-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1937-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1937-12-31 00:00:00 |  | 0 | 0
2038-12-24 00:00:00 | Jan 1st | 1938-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1938-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1938-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1938-12-31 00:00:00 |  | 0 | 0
2039-12-24 00:00:00 | Jan 1st | 1939-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1939-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1939-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1939-12-31 00:00:00 |  | 0 | 0
2040-12-24 00:00:00 | Jan 1st | 1940-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1940-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1940-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1940-12-31 00:00:00 |  | 0 | 0
2041-12-24 00:00:00 | Jan 1st | 1941-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1941-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1941-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1941-12-31 00:00:00 |  | 0 | 0
2042-12-24 00:00:00 | Jan 1st | 1942-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1942-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1942-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1942-12-31 00:00:00 |  | 0 | 0
2043-12-24 00:00:00 | Jan 1st | 1943-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1943-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1943-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1943-12-31 00:00:00 |  | 0 | 0
2044-12-24 00:00:00 | Jan 1st | 1944-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1944-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1944-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1944-12-31 00:00:00 |  | 0 | 0
2045-12-24 00:00:00 | Jan 1st | 1945-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1945-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1945-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1945-12-31 00:00:00 |  | 0 | 0
2046-12-24 00:00:00 | Jan 1st | 1946-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1946-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1946-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1946-12-31 00:00:00 |  | 0 | 0
2047-12-24 00:00:00 | Jan 1st | 1947-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1947-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1947-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1947-12-31 00:00:00 |  | 0 | 0
2048-12-24 00:00:00 | Jan 1st | 1948-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1948-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1948-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1948-12-31 00:00:00 |  | 0 | 0
2049-12-24 00:00:00 | Jan 1st | 1949-03-31 00:00:00 |  | 0 | 0
 | Apr 1st | 1949-06-30 00:00:00 |  | 0 | 0
 | Jul 1st | 1949-09-30 00:00:00 |  | 0 | 0
 | Oct 1st | 1949-12-31 00:00:00 |  | 0 | 0