Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic question about what formulas look at.
Does Excel look at every cell in the range while performing calculations? I
have the following array formula and am wondering if it will slow things down if I change the 12000s to 65536s. By changing the number I would not have to worry about missing any data but then again if it is going to burn my cpu up I will leave it as is. =AVERAGE(IF((SCMatrix!$C2:$C12000="NOW")*(SCMatrix !$Y2:$Y120000),SCMatrix!$Y2:$Y12000)) Thanks! Randy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic Question on Subs | Excel Worksheet Functions | |||
Basic question | Excel Discussion (Misc queries) | |||
Basic INDEX() question | Excel Discussion (Misc queries) | |||
Basic Array Question | Excel Discussion (Misc queries) | |||
Basic Template Question | Excel Discussion (Misc queries) |