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!
sumproduct(A1:A100,B1:B100) + sum(C1:C100) should do it -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-formula-tp4620810p4625084.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
