Array #n/a error

[tuanwa]

All,

I receive the following #N/A error when I drag an array from one cell. However, if I type in the formula in the new cell, press CONTROL-SHIFT-ENTER, there is no error.

Here is the formula I am using:

{=IF(K15=0,"",SUM((JAN!$H$2:$H$25000="Completed")*(JAN!$K$2:$K$25000=$C$1)*(JAN!$J$2:$J25001=A15)*(JAN!$C$2:$C$25000))/K15)}

Any assistance would be greatly appreciated.

Thanks,
Tuan

 

[jasonb75]

You have a missing $ which has caused an extra row in one array when you fill down

{=IF(K15=0,"",SUM((JAN!$H$2:$H$25000="Completed")*(JAN!$K$2:$K$25000=$C$1)*(JAN!$J$2:$J$25001=A15)*(JAN!$C$2:$C$25000))/K15)}

 

[tuanwa]

Thanks a million Jason!!! You saved me a ton of work!