• 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


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

lookup with a dropdown list


New Member
I have a table that shows the list of items, the categories of each item and the number of items sold in a given month.

I would like to create a lead sheet which sums the categories by month. I'd like it to be dynamic and have the month in the drop-down list to allow the user to change to show the data for the month.

how do i write this formula?