Cond. Sum Wizard error msg

J

Julie B

Hello,

While using this wizard for the first time I'm getting the following error
message and am looking for help figuring out what it means.

"Unable to set the FormulaArray property for the Range class."


The source table is about 7,000 rows & includes the following columns:

GL. CC Month Day Year Doc. Description DR/(CR) Acct Type
Source District Region LOB


I'm tryng to sum total amounts in the DR/(CR) column into the following table:

Region A Region B ...
Region E
Distr1 Distr2 Distr3 Distr4
Distr 14 Distr 15
Product A
Source A $aa $bb $cc $dd $ee
$ff
Source B
Source C
Total Product A

Product B
Source A
Source B
Source C
Total Product B

Any assistance will be very much appreciated.
 
Top