even a space anywhere in J2:J529 would cause the formula to fail, you could try using a SUMPRODUCT formula where that wouldn't have such a catastrophic effect - and also doesn't need to be "array-entered"

=SUMPRODUCT(--(time1!$L$2:$L$529=$A77),--(time1!$H$2:$H$529=D$1),time1!$J$2:$J$529)