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 Difficult to say but I suspect that formulas will work better in a structured table.
- OK. Well again, thank you for your time and helpful ideas. I really appreciate them and I'll make some changes to that spreadsheet. I'm sure you are busy but would love to see how you would make that spreadsheet. If not no worries at all. Like I said I just really like excel and try to learn as much as possible from professionals like you guys.
Riny_van_Eekelen Got another question Sir. So I added a qty column and I tried to use a sum function within your countif formula on the right but I can't figure out how to add the qty in those cells you used the countif formula. Any suggestions for this
spalmer Can you upload your file please?