How to sumproduct cell arrays?

[hpr0009]

Typing =SUMPRODUCT({0.5,1,0.5},{4,3,2}) into a cell gives a result of 6. I’m trying to get the same result by putting {0.5,1,0.5} in cell A1, {4,3,2} in cell A2, and =SUMPRODUCT(A1,A2) in cell A3, but when I try this I get the #VALUE error in A3. Is there a way to carry out this SUMPRODUCT with the arrays being drawn from their own separate cells?

 

[Peter_SSs]

Seems like the best thing for me to do at this point is just keep it simple and put each number in it's own cell.

That seems a good idea to me.