This is very similar to an issue I had before with a spreadsheet, and I'm using a similar formula but I cant seem to get it right. Forgive the condition of the sheet, the higher ups want to piece on more functionality without redoing the original workbook. What I am trying to do is take raw sales data from Shipworks and have it populate the monthly sales section. With this functionality we could cut hours off running the monthly sales numbers. However, it needs to be able to draw from the list based upon color as well as the month the sale took place. Unfortunately, the color section is filled in based on what's on another page using a formula as are numerous other fields, adding complictions. I feel the only way to adequately understand the conundrum I have is by providing a pared down copy of the workbook with sales data. The formula I'm using is in B3. I hope I've explained this properly enough and will be checking back frequently to answer any questions, thanks!
Bookmarks