I haven’t used array formulas with LO Calc until now. So i have been doing what I used to do with Excel, this may be the problem but on researching i can’t see the problem. I have an array of 1 by 8, Iam trying to apply this formula:

{ =MMULT(O5:V5, $C$35:$J$35)}

It reports Err:502. i have been unable to work out why. I am sure it is a simple problem staring me in the face. If anyone can help I’d be grateful. the formula is in o6 in this file: