S
Secret Squirrel
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.
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.