• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumif Rows and Column with Data Validation Drop Down

rajkenya1

Member
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.
 

Attachments

  • Sumif row and coloumn.xlsx
    172.6 KB · Views: 9
You are a genius. This works perfectly. Well done and thank you so much for taking the time out here to help. Thank you.
 
Back
Top