Solved, use SUMPRODUCT. But still want to ask a generic question, in case the elements in sum() is not a product, is there a way to specify a range to do that. e.g. sum(A1*B1+C1, A2*B2+C2, ..., A100*B100+C100)? what is the shortest formula for this? Thanks!
On Thu, Jul 21, 2011 at 1:07 PM, Michael Jiang <[email protected]> wrote: > 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 >
