Thank you. This works when using sum but doesn't work for =MMULT(test,TRANSPOSE(test)) the formula I want to use.