need to sum up over 100 products: sum(A1*B1, A2*B2, ..., A100*B100). A formula like this should work, but it is awkward to write 100 product inside sum() in code. Is there a simple way to achieve the same calculation? A range or sth? Thanks!
--Michael
