# Multiplying multiple columns based on current column

1. ## Multiplying multiple columns based on current column

I have the current problem, say I have X columns, A,B,...X, and 5 rows,

I need to multiply:

A1:A5*B1:B5*...*X1:X5

is there a way to do this without having to type in the C,D,E,F... columns etc.?  Register To Reply

2. ## Re: Multiplying multiple columns based on current column

It is not really clear what it is you are multiplying here?

Is it the sum of each of those ranges? Or is it just the product of all the cells in the entire range.  Register To Reply

3. ## Re: Multiplying multiple columns based on current column Originally Posted by NBVC It is not really clear what it is you are multiplying here?

Is it the sum of each of those ranges? Or is it just the product of all the cells in the entire range.
Just term by term,

A B
2 3
3 4

=
6
12  Register To Reply

4. ## Re: Multiplying multiple columns based on current column

So then

=PRODUCT(A1:A5) copied across?  Register To Reply