Ask Your Question

Multiplying column/row ranges [closed]

asked 2012-11-14 20:00:12 +0200

Medieval gravatar image

I have 15 column and I want Calc multiple all these and return answer to one cell. How can I multiple column ranges?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 00:32:40.110612

1 Answer

Sort by » oldest newest most voted

answered 2012-11-14 20:45:59 +0200

Choven gravatar image

The function is product(range). If you want to values in the first row for columns A through E, then in your one cell type: =PRODUCT(A1:E1)

The range A1:E1 could span multiple rows (ex., A1:E5 multiplies all values in the 5x5 matrix). You can also specify more than one range, such as =product(A1:E1, H1:J1).

edit flag offensive delete link more

Question Tools


Asked: 2012-11-14 20:00:12 +0200

Seen: 8,163 times

Last updated: Nov 14 '12