In the attached spreadsheet i want a formula total amount amount in cell d10 which reflects the month in cell d7. So far example if D7 is April 20 then the formula should look at rows d14 to l14 (months) and sum everything in that column. For now i have manually inserted the amount.