Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array formula SUMIF with 2D sum_range array	Rich_84	Excel Worksheet Functions	3	April 3rd 09 10:46 PM
Array formula: how to join 2 ranges together to form one array?	Rich_84	Excel Worksheet Functions	2	April 1st 09 06:38 PM
Find specific value in array of array formula	DzednConfsd	Excel Worksheet Functions	2	January 13th 09 06:19 AM
Tricky array formula issue - Using array formula on one cell, then autofilling down a range	aspenbordr	Excel Programming	0	July 27th 05 03:59 PM
Convert Normal formula to array formula	Pradip Jain	Excel Programming	4	May 23rd 05 04:32 PM

All times are GMT +1. The time now is 01:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us