Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to set formulaarray of range class ERROR when using Conditional Sum
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to set formulaarray of range class ERROR when using Conditional Sum
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:A42DATEVALUE("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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "John H." wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to set the FormulaArrary property of the range class | Excel Worksheet Functions | |||
unable to set the formula array property of the range class | Excel Worksheet Functions | |||
VBA error: Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
error 1004 - metod Copy of class Range was failed | Excel Programming | |||
Unable to set the Locked Property of the Range Class | Excel Programming |