In this video I will demonstrate how to use the advanced filter along with the SumIfs function in the actual worksheet to summarize a cut list from the eCabinets five piece door break down. You can download this work book and follow along at this link.
I will be doing two videos on how to do this. These videos are to prepare you for the series that I will be doing on modifying the five piece door break down from the eCabinets excel workbook.
In the next video I will show you how to do the same thing in VBA. So be sure to stay tuned.
Here is the link.