Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula
Hi All,
If I use a normal formaula in a range of cells it work properly and it is too fast than applying a loop. But when I try the same method on an Array formula it fails. Like the following formula dont work. Is there a way to fis this? Range(Range("A65536").End(xlUp).Offset(0, 1), Range("A2").Offset(0, 3)) _ .FormulaArray = "=SUM(IF(Dt=VALUE(RC1),IF(Loc=R1C,TotSal,0),0) )" Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula
What do you mean by not working? It created a formula in 6 cells for me.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Abdul" wrote in message oups.com... Hi All, If I use a normal formaula in a range of cells it work properly and it is too fast than applying a loop. But when I try the same method on an Array formula it fails. Like the following formula dont work. Is there a way to fis this? Range(Range("A65536").End(xlUp).Offset(0, 1), Range("A2").Offset(0, 3)) _ .FormulaArray = "=SUM(IF(Dt=VALUE(RC1),IF(Loc=R1C,TotSal,0),0) )" Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Formula
Thanks for your quick reply
..FormulaArray = "=SUM(IF(Dt=VALUE(RC1),IF(Loc=R1C,TotSal,0),0) )" Instead of RC1 it always takes R2C1 and instead of R1C it takes R1C2 So it is like absolute refence even thoug only Clolumn is fixed in first part and Row is fixed in the second part. Thanks Bob Phillips wrote: What do you mean by not working? It created a formula in 6 cells for me. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Abdul" wrote in message oups.com... Hi All, If I use a normal formaula in a range of cells it work properly and it is too fast than applying a loop. But when I try the same method on an Array formula it fails. Like the following formula dont work. Is there a way to fis this? Range(Range("A65536").End(xlUp).Offset(0, 1), Range("A2").Offset(0, 3)) _ .FormulaArray = "=SUM(IF(Dt=VALUE(RC1),IF(Loc=R1C,TotSal,0),0) )" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Convert Normal formula to array formula | Excel Programming |