Thanks driller I will take that into consideration. It might be a better way
to handle this worksheet since it's getting rather large. Appreciate your
input!

SS

"driller" wrote:

Hi Secret Squirrel,

for summing and/or with grouping of your invoice records [by dates, by
class, by numbers, by whichever] in the spreadsheet, may i suggest that you
use excel's pivot table...
regards
--
*****
birds of the same feather flock together..



"Secret Squirrel" wrote:

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.