unable to set formulaarray of range class ERROR when using Conditional Sum

  • Thread starter Thread starter John H.
  • Start date Start date
J

John H.

I am attempting to total data which i imported from a .mdb.
I will try to explain the best i can
I have 4 colums that i am using they represent the following:
Col-1:Date
Col-2:Company
Col-3:Type
Col-4:contains the number 1 (just so it can add the occurences)

What i am attempting to do is search add the number of occurrences
that:
Date is between: 01/01/03 and 01/31/03
Company = 2
Type = 6

Using conditional Sum i select the range
Select the column to sum as col-4
Select condition Date >= 01/01/2003
Select condition Date <= 01/31/2003
Select condition Company = 2
Select condition Type = 6

On Step 3 of 4 (to copy the value to a cell), i shows the correct
answer in the box. However after i select the cell and select finish,
it gives me:
Run-time error '1004' Unable to set the formulaArray property of the
range class

Anyone have any ideas? Like i said in step 3 of 4 on Conditional Sum
in the box, it shows the correct total, but after i select the cell
and select finish, error. Any help would be greatly appriciated. By
the way i am using Excel 2000 SR-1
 
John

I just tried something similar and it worked fine. You should try to write
the formula manually and see if that gives any kind of error. It will look
like this

=SUM((A1:A42>DATEVALUE("1/1/03"))*(A1:A42<DATEVALUE("1/31/03"))*(B1:B42=2)*(
C1:C42=6)*(D1:D42))

That should be all on one line. Change A1:A42, etc. to your actual ranges.
Make sure you enter with Control+Shift+Enter, not just Enter.
 
Back
Top