Autofill Array Functions
 

Hi,

I'm using array functions to calculate conditional sums for attendance by
department, but when I drag the bottom right box to autofill across rows and
columns, it simply copies the values I already have. After dragging the
formulas around I have to go through each cell, double click and then use
Cntrl-Shift-Enter.

The problem is that I would have to do this for 240x13 cells, and I just
don't have the time. Is there any way to get Excel to calculate the array
formulas in all these cells at once??

Thanks!

Autofill Array Functions
 

Had it on manual calculation, pressed F9 and everything worked out

"Robert" wrote:

Hi,

I'm using array functions to calculate conditional sums for attendance by
department, but when I drag the bottom right box to autofill across rows and
columns, it simply copies the values I already have. After dragging the
formulas around I have to go through each cell, double click and then use
Cntrl-Shift-Enter.

The problem is that I would have to do this for 240x13 cells, and I just
don't have the time. Is there any way to get Excel to calculate the array
formulas in all these cells at once??

Thanks!