I am making a cover page where someone would enter in a date. I want to create a formula that looks at another table where it would sum all the values before that date. For example, when they type in 10/27/2019 it goes to the table finds 10/27/2019 then returns back all the values(in the next column over) before that date.
multiple vlookup and hlookup combinations with sum product.
10/18/2019 5000.00
10/19/2019 5000.00
10/20/2019 5000.00
10/21/2019 5000.00
10/22/2019 5000.00
10/23/2019 5000.00
10/24/2019 5000.00
10/25/2019 5000.00
10/26/2019 5000.00
10/27/2019 5000.00
10/28/2019 5000.00
A year to date sum.
