I'm trying to sum invoice amounts for a specific customer by date. Along with
that I also want to group them by class. I have 3 classes, 1, 2, and 3.
Here's a little snap shot of my worksheet


Column A Column B Column C Column D
(Inv Date) (Customer) (Inv Amt) (Class)

2/1/2007 MyCompany $100.00 1
2/1/2007 MyCompany $100.00 1
2/1/2007 MyCompany $100.00 2
2/2/2007 MyCompany $100.00 1
2/2/2007 MyCompany $100.00 3


So on my summary worksheet I have the following:

2/1/2007 $200.00 for class 1
2/1/2007 $100.00 for class 2
2/2/2007 $100.00 for class 1
2/2/2007 $100.00 for class 3

I have multiple customers so I only want to single out one company. I'm
using "MyCompany" as the example name of the company.

Any help would be greatly appreciated.