Forum Discussion
Formula Help
spalmer The attached file now contains a lookup table for all the products, colours and sizes. This makes it easier to match the individual order rows to the correct prices. You will note that I have used several named ranges to make it all easier to write and maintain. Furthermore, I added a few COUNTIFS in the order summary for Hats, as I expect that would have been your next question. Perhaps you find my changes useful in completing the schedule for the other products as well.
And I can think of many more improvements, and would probably come-up with a totally different approach. But it's beyond the scope of this forum to go into details.
spalmer The attached file now contains a lookup table for all the products, colours and sizes. This makes it easier to match the individual order rows to the correct prices. You will note that I have used several named ranges to make it all easier to write and maintain. Furthermore, I added a few COUNTIFS in the order summary for Hats, as I expect that would have been your next question. Perhaps you find my changes useful in completing the schedule for the other products as well.
And I can think of many more improvements, and would probably come-up with a totally different approach. But it's beyond the scope of this forum to go into details.
Sir, thank you so much! I really appreciate your time and help in this and would really like to hear your thoughts and recommendationsabout this. I love excel and always love to hear opinions on how to make better spreadsheets. Thank you again Riny_van_Eekelen