Autofill Array Functions

[Robert]

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!

 

[Robert]

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