poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Jiang <it.mjji...@gmail.com>
Subject Excel formula
Date Thu, 21 Jul 2011 20:07:59 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message