I have a worksheet called "data" which contains raw data that I need to
summarize. Column G contains the type of wigit (in text i.e. silver pipe),
column E contains the date purchased.

In another worksheet, same workbook I want to be be able to calcualte the
number of silver pipes by month. Keep in mind that column E contains multiple
instances per month. Data is also captured for 12 months of the year

Thanks